I want to search in the shp inside Mapguide repo, never mind the word is accented or not.
Ex: inside dbf = 'espíritu' Search value='espíritu' or 'espiritu' show us the result in the db: 'espíritu' is it clear? tips: I found this sentence, but doen't work in a filter (tested on a MySQL table and it works) SELECT * FROM content WHERE REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE ( LOWER(mycolumn),'á','a'), 'é','e'),'í','i'),'ó','o'),'ú','u'),'ñ','n') = 'espíritu'; -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/accented-fields-in-a-shp-tp4997520p4997520.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users