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

[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.listes at codata.eu>

> Arnaud Lesauvage a écrit :
>
>> 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.
>
> Arnaud
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091016/3548b9a2/attachment.html>