Re: [GENERAL] pgsql2shp : Encoding headache

2009-10-16 Thread Arnaud Lesauvage
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 mygeo

Re: [GENERAL] pgsql2shp : Encoding headache

2009-10-16 Thread Arnaud Lesauvage
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 sh

Re: [GENERAL] pgsql2shp : Encoding headache

2009-10-16 Thread Raymond O'Donnell
On 16/10/2009 10:36, Arnaud Lesauvage wrote: > I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled > database. I want my shapefile to be encoded in WIN1252, and a particular > field to be in uppercase. > > Since I am on windows, I don't have an iconv executable. Therefore, I am