Can you change your query to UC(string1) == UC(string2)
*NOTE* the syntax may not be perfect, but you should be able to get my drift... Martin Morrison Application Engineer Engineering Design Systems, Inc. 3780 Peters Creek Rd Ext SW Roanoke, VA 24018 540.345.1410 gis.edsi.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Gord McKenzie Sent: Monday, April 27, 2015 5:29 PM To: MapGuide Users Mail List Subject: Re: [mapguide-users] Mapguide and ODBC Here is the scoop. When the SQL Database has a string like 'xxx123' and the sdf has a string like 'XXX123' then the records don't match and that is the substance of the problem. In AutoCAD Map, each id that is mismatched by case is still missing it's joined attributes. However record matching continues with just the few case based mismatches. When Mapguide does this, it hits the first mismatch and nothing else is matched after that. In SQL Server, by default it has no trouble joining on xxx and XXX. Gordon McKenzie GIS Coordinator T: 403.269.8887 / 1.800.478.6162 E: [email protected] canam.com 900, 340 - 12th Avenue SW Calgary, AB T2R 1L5 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jackie Ng Sent: Sunday, April 26, 2015 8:56 PM To: [email protected] Subject: Re: [mapguide-users] Mapguide and ODBC I'm afraid at this point, we'll need a small reproducible sample of this problematic SDF/SQL Server join in order to look at this issue any further. Something that is 50-100 rows on either side with the sensitive information (except for the joining keys) sanitized/replaced should be sufficient. IIRC MapGuide and AutoCAD Map share the same Feature Join engine. I'd be interested to know if this SDF <-> SQL Server join looks the same in AutoCAD Map 2013 or newer should you have access to such a version. - Jackie -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-and-ODBC-tp5202365p5203003.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
