[postgis-users] Shp2pgsql : unable to convert french UTF8encoded shapefiles

Alexandre Gacon alexandre.gacon at masagroup.net
Mon Feb 4 07:40:32 PST 2008

Hi Michael,

I have checked my data and it is UTF8 (the 'é' character is encoded as E9).

The "SHOW client_encoding" return UNICODE as result. The encoding field of
my database displays UTF8.

I join a small shapefile to test with.

I use the following commands

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


pgsql -d gis_database -f myfile.sql -U postgres.


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 16:28
À : PostGIS Users Discussion
Objet : Re: [postgis-users] Shp2pgsql : unable to convert french UTF8encoded

On Mon, Feb 04, 2008 at 10:29:17AM +0100, Alexandre Gacon wrote:
> I am trying to load several shapefiles provided by TéléAtlas in a 
> postgis database with shp2pgsql on Windows XP and I have several problems.
> The shapefiles contains the data for France and are encoded in UTF8.

Are you certain the data is UTF-8?  Have you verified by looking at a hex
dump?  Might some or all of it be in another encoding?

> If I generates pgsql files without indicating the encoding to use, 
> shp2pgsql works fine but I can't execute the file with psql : I got an 
> error about an "Illegal byte sequence". If I open a pgsql file with 
> the pgAdmin tool, I manage to execute the sql request and it works fine.

What does "SHOW client_encoding" return in pgAdmin?

> This solution helps me but it is not enough : I can't do this for 
> large shapefiles (the pgAdmin tool can not open the file) and I have 
> several hundreds of files to load.
> If I try to generate the pgsql file with the -W "UTF8" option, I got 
> the same error than the psql command : "utf8 : Illegal byte sequence".

Do you have a small shapefile you could make available for others to test
with?  What are the exact shp2pgsql and psql commands you're using?

Michael Fuhr
postgis-users mailing list
postgis-users at postgis.refractions.net
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 94034______.zip
Type: application/x-zip-compressed
Size: 5625 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080204/532f8c18/attachment.bin>

More information about the postgis-users mailing list