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,
Regina
________________________________
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of
Marcello Brunaldi
Sent: Friday, February 13, 2009 8:59 AM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Error in importing shape files to the
PostGISdatabase
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
encoding"
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.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
