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?
But then, if I dump it through a query to have my field in uppercase, I get an error 'character 0xc29f of encoding UTF8 has no equivalent in WIN1252' (translated by myself, the message is in French) The command is simply : pgsql2shp -f myouput.shp -u postgres -g mygeom mydatabase "SELECT upper(mytext) as mytext, mygeom FROM mytemptable"
OK, I narrowed down the problem to the WIN1252 encoding. Using LATIN1 or LATIN9 for instance works correctly. Since my application seems to work with LATIN9, I'll go with it.
I am still perplex though. What is this 0xc29f character ? An internet search tells me that this is some Kanju character. I am quite confident that if this is true, it would not convert any better to LATIN9 than to WIN1252.
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 ?
Thanks again for your help/lightings on this matter.
