[fdo-internals] RE: [mapguide-internals] Case sensitivitychangeinMGOS 1.2?

Robert Fortin robert.fortin at autodesk.com
Tue Oct 9 15:56:46 EDT 2007


Jason,

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


RF

-----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 3:29 PM
To: FDO Internals Mail List; MapGuide Internals Mail List
Subject: RE: [fdo-internals] RE: [mapguide-internals] Case
sensitivitychangeinMGOS 1.2?

OK, thanks.  

It would be useful if there was some way of overriding this.  I want my
users to be able to find things without having special knowledge of the
data.  If there is a lower() or upper() function in SDF, I guess I could
use that to force comparison of like-case?

Jason

-----Original Message-----
From: fdo-internals-bounces at lists.osgeo.org
[mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Traian
Stanev
Sent: Tuesday, October 09, 2007 11:56
To: FDO Internals Mail List; MapGuide Internals Mail List
Subject: RE: [fdo-internals] RE: [mapguide-internals] Case sensitivity
changeinMGOS 1.2?

I think at some point the behavior of LIKE was changed from case
insensitive (like old MapGuide) to case sensitive. I'm fuzzy on the
details of when that happened.

Traian


> -----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 2:54 PM
> To: MapGuide Internals Mail List; FDO Internals Mail List
> Subject: [fdo-internals] RE: [mapguide-internals] Case sensitivity 
> change inMGOS 1.2?
> 
> I suppose that I should be explicit:  the case sensitivity is around 
> attribute values in filters.  Such as lastname like 'Smith' not 
> returning rows where lastname == 'SMITH'.
> 
> Jason
> 
> -----Original Message-----
> From: Jason Birch
> Subject: [mapguide-internals] Case sensitivity change in MGOS 1.2?
> 
> Anyone know if something has changed in MapGuide 1.2 or FDO 3.2.3 that

> would cause my SDF queries to be case sensitive, where they weren't in

> 1.1?  Does this have anything to do with the locale changes?
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals


_______________________________________________
fdo-internals mailing list
fdo-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-internals
_______________________________________________
fdo-internals mailing list
fdo-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-internals



More information about the fdo-internals mailing list