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

[Micha Silver]

On 11/06/2010 09:32 PM, Lenny Sorey wrote:
>
>
>   [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.
>

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.

> Sorry for the bother.
>
> Lenny
>
>
>
> On Fri, Nov 5, 2010 at 4:40 PM, Lenny Sorey <lsorey at gmail.com 
> <mailto: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
>
>
>
>
> This mail was received via Mail-SeCure System.
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> This mail was received via Mail-SeCure System.
>
>
>    


-- 
Micha Silver
Arava Development Co. +972-52-3665918
http://surfaces.co.il


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20101106/dd3a6e5e/attachment.html>