Re: pgsql2shp : Encoding headache - Mailing list pgsql-general

From Arnaud Lesauvage
Subject Re: pgsql2shp : Encoding headache
Date
Msg-id 4AD84C1A.5070804@codata.eu
Whole thread Raw
In response to Re: pgsql2shp : Encoding headache  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Raymond O'Donnell a écrit :
> If it's any help to you, you can get iconv (and a bunch of other helpful
> stuff) from GnuWin32:
>
>   http://gnuwin32.sourceforge.net/

Thanks for your help Raymond.

I tried iconv but I have other problems now.
I still have to load the file into postgresql because the shapefiles
datafile (.dbf) is associated with an index file, and I have to use
pgsql2shp to rebuild it.
I'll try some more though. Maybe iconv before shp2pgsql, then load with
client_encoding set to WIN1252, then dump.
I'll see how it goes.

Arnaud

pgsql-general by date:

Previous
From: InterRob
Date:
Subject: Re: [postgis-users] pgsql2shp : Encoding headache
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: savepoint name vs prepared transaction name