[postgis-users] Shp2pgsql : unable to convert frenchUTF8encoded shapefiles

Alexandre Gacon alexandre.gacon at masagroup.net
Mon Feb 4 23:56:10 PST 2008


Thank you for your help, it works fine now.

Alexandre Gacon 

-----Message d'origine-----
De : postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] De la part de Michael
Envoyé : lundi 4 février 2008 18:45
À : PostGIS Users Discussion
Objet : Re: [postgis-users] Shp2pgsql : unable to convert frenchUTF8encoded

On Mon, Feb 04, 2008 at 04:40:32PM +0100, Alexandre Gacon wrote:
> I have checked my data and it is UTF8 (the 'é' character is encoded as

é <U+00E9 LATIN SMALL LETTER E WITH ACUTE> in UTF-8 is <c3 a9>.
If you see it encoded as <e9> then the encoding is probably LATIN1, LATIN9,
or WIN1252.

> shp2pgsql fra94034______00 teleatlas_2007.testdb -W "UTF-8" > 
> myfile.sql

I was able to load this data into a UTF-8 database if I used "-W LATIN1".

Michael Fuhr
postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list