[postgis-users] Postgis to ESRI shape file encoding problem

[Ervin Ramonllari]

Ok, thnx
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,

regards
Ervin




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



Hello,

You have an error in this sentence,
you should use it like this



ALTER DATABASE DBIPRS
SET client_encoding=latin2;



Regards

Maher











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
        

        To:
       PostGIS Users Discussion <postgis-users at postgis.refractions.net>

        cc:
       

        Subject:
       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
"pgclientencoding"

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
to the

> encoding value you need (e.g. LATIN2).

> 

> Steffen

> 

> >> 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

> http://postgis.refractions.net/mailman/listinfo/postgis-users




Discover the new Windows Vista Learn
more!_______________________________________________

postgis-users mailing list

postgis-users at postgis.refractions.net

http://postgis.refractions.net/mailman/listinfo/postgis-users




_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080721/8ca41b3c/attachment.html>