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

Lenny Sorey lsorey at gmail.com
Fri Nov 5 17:40:35 EDT 2010


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/20101105/61416028/attachment.html


More information about the Qgis-user mailing list