[postgis-users] encoding

[jj.wag at gmx.de]

Thanks Ralf,
I don't understand how to use this.
pgsql2shp -f myshape mydb -h localhost -P xxxx -u postgres mytable -export 
PGCLIENTENCODING=LATIN1 ????

I'm using PostGIS 1.3.5 on an Windows-System
Thanks
Jo


----- Original Message ----- 
From: "Ralf Suhr" <Ralf.Suhr at itc-halle.de>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Thursday, May 06, 2010 3:38 PM
Subject: Re: [postgis-users] encoding


> Hi Jo,
>
> export PGCLIENTENCODING=LATIN1; pgsql2shp ...
>
> will work
>
> Gr
> Ralf
>
> Am Donnerstag 06 Mai 2010 15:30:35 schrieb jj.wag at gmx.de:
>> Hi,
>> If I try to load a Latin1 Shape to my UTF-8 database there is no Problem 
>> to
>> convert the encoding:
>> shp2pgsql -d -s 31466 -W Latin1 -I myshape mytable | psql -U postgres -d
>> mydb
>>
>> But if I want to export with pgsql2shp there is no flag to convert the
>> encoding from utf-8 to latin1
>> With ogr2ogr I have the same problem.
>> Any idea?
>>
>> Greetings Jo
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>