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

[Jason Birch]

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)?

Jason

-----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%'