[mapguide-users] accented fields in a shp

[Jose Cerrejon]

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.