<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 11/06/2010 09:32 PM, Lenny Sorey wrote:
<blockquote
cite="mid:AANLkTinCK0ZQszEReM+4mFc6oy9sWzT+-JPT2SoWBLE5@mail.gmail.com"
type="cite">
<h1 class="ha">[SOLVED] <font size="4"><span id=":3c" class="hP">Problems
inserting into Postgres (PostGis 1.5) from Shapefile</span></font></h1>
<br>
<br>
Upgraded PostgreSQL 8.4 to to PostgreSQL 9.0 and updated to POSTGIS
1.5.2-3 for PostgreSQL 9<br>
<br>
This did the trick.<br>
<br>
I now can use PostGIS Shapefile and DBF Loader or SPIT Plugin in QGIS
with no "UTF8": issues.<br>
<br>
</blockquote>
<br>
The command line utility, shp2pgsql, has the -W option to indicate the
encoding of the source data tables. That should help to convert the
input encoding to UTF-8 that Postgresql expects.<br>
<br>
<blockquote
cite="mid:AANLkTinCK0ZQszEReM+4mFc6oy9sWzT+-JPT2SoWBLE5@mail.gmail.com"
type="cite">Sorry for the bother.<br>
<br>
Lenny<br>
<br>
<br>
<br>
<div class="gmail_quote">On Fri, Nov 5, 2010 at 4:40 PM, Lenny Sorey <span
dir="ltr"><<a moz-do-not-send="true" href="mailto:lsorey@gmail.com">lsorey@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Having
a bit of a problem insert shapefile data into Postgres (PostGIS 1.5)<br>
using either the SPIT plugin or directly from PostGIS Shapefile and DBF
Loader<br>
<br>
I have imported a number of times into Postgres (PostGIS 1.5) from
Shapefiles<br>
nor downloaded from ArcSDE 10.<br>
<br>
Was just curious if anyone else has run into this problem.<br>
<br>
I created the standalone shapefiles from an ESRI Geodatabase ARCDSE 10<br>
by exporting to shapefiles via ArcCatalog 10.<br>
<br>
The geodatabase is SQL Server 2008 Enterprise<br>
<br>
The error message from SPIT is as follows:<br>
<br>
Problem inserting features from file:
<p style="margin: 0px; text-indent: 0px;">C:/ESRI_Shapfiles_Geodatabase/Bunker.shp</p>
<p style="margin: 0px; text-indent: 0px;">The database gave an
error while executing this SQL:</p>
<p style="margin: 0px; text-indent: 0px;">INSERT INTO
"public"."Bunker"("FacilityID","BunkerID","DateCreate","DateModifi","BunkerType","Drained","Depth","HoleInfoID","CourseDefI","FilePath","S...
(rest of SQL trimmed)</p>
<p style="margin: 0px; text-indent: 0px;">The error was:</p>
<p style="margin: 0px; text-indent: 0px;">ERROR: invalid byte
sequence for encoding "UTF8": 0x80</p>
<p style="margin: 0px; text-indent: 0px;">HINT: This error can also
happen if the byte sequence does not match the encoding expected by the
server, which is controlled by "client_encoding".</p>
<p style="margin: 0px; text-indent: 0px;"><br>
</p>
<p style="margin: 0px; text-indent: 0px;">Thanks,</p>
<p style="margin: 0px; text-indent: 0px;"><br>
</p>
<font color="#888888">
<p style="margin: 0px; text-indent: 0px;">Lenny<br>
</p>
<br>
</font></blockquote>
</div>
<br>
<br>
This mail was received via Mail-SeCure System.<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
Arava Development Co. +972-52-3665918
<a class="moz-txt-link-freetext" href="http://surfaces.co.il">http://surfaces.co.il</a>
</pre>
</body>
</html>