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

[Alexandre Gacon]

Hi,

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
Fuhr
Envoyé : lundi 4 février 2008 18:45
À : PostGIS Users Discussion
Objet : Re: [postgis-users] Shp2pgsql : unable to convert frenchUTF8encoded
shapefiles

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
E9).

é <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
http://postgis.refractions.net/mailman/listinfo/postgis-users