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

[Gabriel Messner]

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!<http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE>
>
> _______________________________________________
> 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!<http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE>
>
> _______________________________________________
> 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!
> <http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080718/65420d72/attachment.html>