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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
