Re: [postgis-users] pgsql2shp : Encoding headache

From: InterRob <rob(dot)marjot(at)gmail(dot)com>
To: PostGIS Users Discussion <postgis-users(at)postgis(dot)refractions(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [postgis-users] pgsql2shp : Encoding headache
Date: 2009-10-16 15:35:54
Message-ID: 671e36b0910160835w69ccf483n450f002b54ab0543@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)listes(at)codata(dot)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(dot)refractions(dot)net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-10-16 16:20:09 Re: Urgent Help required
Previous Message Grzegorz Jaśkiewicz 2009-10-16 14:57:19 Re: savepoint name vs prepared transaction name