[Qgis-user] Re: Problems inserting into Postgres (PostGis 1.5) from Shapefile
Micha Silver
micha at arava.co.il
Sat Nov 6 12:48:45 PDT 2010
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>
More information about the Qgis-user
mailing list