<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16788" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=868333114-13022009><FONT face=Arial
color=#0000ff size=2>Use the -W latin1 switch in shp2pgsql and see if that fixes
it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=868333114-13022009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=868333114-13022009><FONT face=Arial
color=#0000ff size=2>the latin1 should be the encoding of your file, but latin1
always seems to work for my datasets anyway.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=868333114-13022009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=868333114-13022009><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=868333114-13022009><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Marcello Brunaldi<BR><B>Sent:</B> Friday, February 13, 2009 8:59
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Error in importing shape files to the
PostGISdatabase<BR></FONT><BR></DIV>
<DIV></DIV>Hello everyone<BR>I have the shape file format utm32 and I have to
import them into my database PostGIS ,<BR>with this command : shp2pgsql -s 23032
point.shp point | psql postgis <BR>Some of these files during import have caused
the error :<BR>invalid byte sequence for encoding utf 8 0xe02076<BR>this error
can also happen if the byte sequence does not match the encoding expected by the
server, which is controlled by "client encoding"<BR><BR>My database is enconding
UTF8.<BR></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>