[fdo-internals] RE: [mapguide-internals]CasesensitivitychangeinMGOS 1.2?

Robert Fortin robert.fortin at autodesk.com
Tue Oct 9 16:12:24 EDT 2007

If I remember well, SDF doesn't index property other than the id.
So I don't think it would bring performance penalty.  


-----Original Message-----
From: fdo-internals-bounces at lists.osgeo.org
[mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Jason Birch
Sent: Tuesday, October 09, 2007 4:00 PM
To: MapGuide Internals Mail List; FDO Internals Mail List
Subject: RE: [fdo-internals] RE:
[mapguide-internals]CasesensitivitychangeinMGOS 1.2?

Thanks Robert.

It would be nice if there was a way of specifying a case-insensitive
collation that could be used for things like sort and search, but I
guess I'll have to live with the workaround.

Is there a performance penalty to doing this (ie, does using this method
defeat any internal indexing)?


-----Original Message-----
From: Robert Fortin
Subject: RE: [fdo-internals] RE: [mapguide-internals]
CasesensitivitychangeinMGOS 1.2?

That change was done around March (in build 54), to make the "like"
operation consistent with the rest of the other operations. 
It means "Like" is now case sensitive.

And yes, with this, it included support for lower and upper function so
that your call can be replaced with something like this

Upper(lastname) like 'SMITH%'
fdo-internals mailing list
fdo-internals at lists.osgeo.org

More information about the fdo-internals mailing list