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

[Ervin Ramonllari]

I tried that solution, but the result is the same as before.

Maybe I should get rid of those nasty characters before exporting to shape.

Thank you very much for your help.

Ervin.



Date: Fri, 18 Jul 2008 13:52:22 +0200
From: gabmessner at gmail.com
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Postgis to ESRI shape file encoding problem

yes, you´re right; -W option only works with loader shp2pgsql.

The second option may be to define in the pgsql.conf file the following line:

client_encoding = sq-iso-8859-1 (i´not sure if Postgresql recognize the character encoding Latin1 for albanian as sq-iso-8859-1, but try with it or search the equivalent and write it in the pgsql.conf file). Afterwards, execute the dumper (pgsql2shp).




2008/7/18 Ervin Ramonllari <ervin.ramonllari at hotmail.com>:





I tried that,
it gives back an error. It doesn't recognize -W as an option or command.



Date: Fri, 18 Jul 2008 13:24:28 +0200

From: gabmessner at gmail.com
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Postgis to ESRI shape file encoding problem


Try pgsql2shp option: 

-W sq-iso-8859-1

2008/7/18 Ervin Ramonllari <ervin.ramonllari at hotmail.com>:






In Albanian, there are 4 special characters.



Date: Fri, 18 Jul 2008 12:33:55 +0200
From: gabmessner at gmail.com


To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Postgis to ESRI shape file encoding problem



In wich language are data?

2008/7/18 Ervin Ramonllari <ervin.ramonllari at hotmail.com>:











Hello everybody,

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

the
export is done correctly, but some special characters could not be
exported properly. I guess it's a problem of encoding but I can't
figure out how to deal with it.

I googled around but couldn't find something useful.

Any help for solving my problem would be highly appreciated,

thanks in advance,

Ervin.
Explore the seven wonders of the world Learn more!




_______________________________________________

postgis-users mailing list

postgis-users at postgis.refractions.net

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





Explore the seven wonders of the world Learn more!

_______________________________________________

postgis-users mailing list

postgis-users at postgis.refractions.net

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





Connect to the next generation of MSN Messenger   Get it now! 


_______________________________________________

postgis-users mailing list

postgis-users at postgis.refractions.net

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





_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080718/50514796/attachment.html>