[fdo-internals] RE: [mapguide-internals]
Jason.Birch at nanaimo.ca
Tue Oct 9 16:00:14 EDT 2007
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)?
From: Robert Fortin
Subject: RE: [fdo-internals] RE: [mapguide-internals]
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%'
More information about the fdo-internals