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

Arnaud Lesauvage arnaud.listes at codata.eu
Fri Oct 16 03:34:02 PDT 2009


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



More information about the postgis-users mailing list