[postgis-users] Postgis to ESRI shape file encoding problem
ervin.ramonllari at hotmail.com
Mon Jul 21 06:34:31 PDT 2008
but i have tried this solution before.
It looks like a problem with the shape or most probably with the dbf file encoding. the dbf encoding should be SQL_ASCII.
Actually, if you try to save an Excel spreadsheet( which contains special character - Ë, Ç ) as a dbf file, the result is the same as in my exercise. The special characters can later be replace by using ArcView or ArcMap.
I just decided to remove my special characters from my database, so it's not a concern anymore (for this time, a solution has to be found anyway).
Just, for curiosity, has somebody had the same problem as mine?
Thanks to all you guys,
To: postgis-users at postgis.refractions.net
CC: postgis-users at postgis.refractions.net; postgis-users-bounces at postgis.refractions.net
Subject: RE: [postgis-users] Postgis to ESRI shape file encoding problem
From: Maher_Karim at dorsch.com.jo
Date: Mon, 21 Jul 2008 14:48:20 +0300
You have an error in this sentence,
you should use it like this
ALTER DATABASE DBIPRS
Ervin Ramonllari <ervin.ramonllari at hotmail.com>
Sent by: postgis-users-bounces at postgis.refractions.net
07/21/2008 01:33 PM
Please respond to PostGIS Users Discussion
PostGIS Users Discussion <postgis-users at postgis.refractions.net>
RE: [postgis-users] Postgis to ESRI
shape file encoding problem
I tried this way :
ALTER DATABASE DBIPRS SET PGCLIENTENCODING to 'Latin2'
but i got the error:
ERROR: unrecognized configuration parameter
SQL state: 42704
> Date: Sat, 19 Jul 2008 14:37:37 +0200
> From: sdteffen at gmail.com
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] Postgis to ESRI shape file encoding problem
> You can also try to set the environment variable PGCLIENTENCODING
> encoding value you need (e.g. LATIN2).
> >> I'm trying to export some data from a Postgresql database
encoded in UTF-8
> >> into some ESRI shape files.
> >> I'm using PostGIS Dumper (pgsql2shp).
> postgis-users mailing list
> postgis-users at postgis.refractions.net
Discover the new Windows Vista Learn
postgis-users mailing list
postgis-users at postgis.refractions.net
Discover the new Windows Vista
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users