[Qgis-user] Re: Problems inserting into Postgres (PostGis 1.5) from Shapefile

[Lenny Sorey]

[SOLVED] Problems inserting into Postgres (PostGis 1.5) from Shapefile

Upgraded PostgreSQL 8.4 to to PostgreSQL 9.0 and updated to POSTGIS 1.5.2-3
for PostgreSQL 9

This did the trick.

I now can use PostGIS Shapefile and DBF Loader or SPIT Plugin in QGIS with
no "UTF8": issues.

Sorry for the bother.

Lenny



On Fri, Nov 5, 2010 at 4:40 PM, Lenny Sorey <lsorey at gmail.com> wrote:

> Having a bit of a problem insert shapefile data into Postgres (PostGIS 1.5)
> using either the SPIT plugin or directly from PostGIS Shapefile and DBF
> Loader
>
> I have imported a number of times into Postgres (PostGIS 1.5) from
> Shapefiles
> nor downloaded from ArcSDE 10.
>
> Was just curious if anyone else has run into this problem.
>
> I created the standalone shapefiles from an ESRI Geodatabase ARCDSE 10
> by exporting to shapefiles via ArcCatalog 10.
>
> The geodatabase is SQL Server 2008 Enterprise
>
> The error message from SPIT is as follows:
>
> Problem inserting features from file:
>
> C:/ESRI_Shapfiles_Geodatabase/Bunker.shp
>
> The database gave an error while executing this SQL:
>
> INSERT INTO
> "public"."Bunker"("FacilityID","BunkerID","DateCreate","DateModifi","BunkerType","Drained","Depth","HoleInfoID","CourseDefI","FilePath","S...
> (rest of SQL trimmed)
>
> The error was:
>
> ERROR: invalid byte sequence for encoding "UTF8": 0x80
>
> 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".
>
>
> Thanks,
>
>
> Lenny
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20101106/761905cd/attachment.html>