[postgis-users] Error in importing shape files to the PostGISdatabase

Obe, Regina robe.dnd at cityofboston.gov
Fri Feb 13 06:32:43 PST 2009

Use the -W latin1 switch in shp2pgsql and see if that fixes it.
the latin1 should be the encoding of your file, but latin1 always seems
to work for my datasets anyway.
Hope that helps,


From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Marcello Brunaldi
Sent: Friday, February 13, 2009 8:59 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Error in importing shape files to the

Hello everyone
I have the shape file format utm32 and I have to import them into my
database PostGIS ,
with this command : shp2pgsql -s 23032 point.shp point | psql postgis 
Some of these files during import have caused the error :
invalid byte sequence for encoding utf 8 0xe02076
this error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client

My database is enconding UTF8.

The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090213/278ad5e3/attachment.html>

More information about the postgis-users mailing list