Re: [postgis-users] [GENERAL] pgsql2shp : Encoding headache

2009-10-21 Thread Arnaud Lesauvage
InterRob a écrit : >> Arnaud Lesauvage a écrit : >> Also, doing a search like : >> SELECT * FROM mytable WHERE upper(myflied) ILIKE u&'%c29f%'; >> Gives me 0 result. >> Am I wrong to think that the error 'character 0xc29f of UTF8' relates >> to the character with code point C29F in UTF8 ? > I wou

Re: [postgis-users] [GENERAL] pgsql2shp : Encoding headache

2009-10-16 Thread InterRob
I would do this last query searching for the 0xC29F character WITHOUT the upper() function on the source table, in the native (to table) UTF8 client encoding. No result either? Rob 2009/10/16 Arnaud Lesauvage > Arnaud Lesauvage a écrit : > >> But then, if I dump it through a query to have my fi