<div dir="ltr">yes, youŽre right; -W option only works with loader shp2pgsql.<br><br>The second option may be to define in the pgsql.conf file the following line:<br><br>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).<br>
<br><br><br><div class="gmail_quote">2008/7/18 Ervin Ramonllari <<a href="mailto:ervin.ramonllari@hotmail.com">ervin.ramonllari@hotmail.com</a>>:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div style="text-align: left;">I tried that,<br>it gives back an error. It doesn't recognize -W as an option or command.<br></div><br><br><br><hr>Date: Fri, 18 Jul 2008 13:24:28 +0200<div><div></div><div class="Wj3C7c">
<br>From: <a href="mailto:gabmessner@gmail.com" target="_blank">gabmessner@gmail.com</a><br>To: <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>Subject: Re: [postgis-users] Postgis to ESRI shape file encoding problem<br>
<br><div dir="ltr">Try pgsql2shp option: <br><br>-W sq-iso-8859-1<br><br><div>2008/7/18 Ervin Ramonllari <<a href="mailto:ervin.ramonllari@hotmail.com" target="_blank">ervin.ramonllari@hotmail.com</a>>:<br><blockquote style="padding-left: 1ex;">
<div><div style="text-align: left;">In Albanian, there are 4 special characters.<br></div><br><br><br><hr>Date: Fri, 18 Jul 2008 12:33:55 +0200<br>From: <a href="mailto:gabmessner@gmail.com" target="_blank">gabmessner@gmail.com</a><br>
To: <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>Subject: Re: [postgis-users] Postgis to ESRI shape file encoding problem<div><br><br><div dir="ltr">
In wich language are data?<br><br><div>2008/7/18 Ervin Ramonllari <<a href="mailto:ervin.ramonllari@hotmail.com" target="_blank">ervin.ramonllari@hotmail.com</a>>:<br><blockquote style="padding-left: 1ex;">
<div><div style="text-align: left;">
</div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">Hello everybody,<br><br>I'm trying to export some data from a Postgresql database encoded in UTF-8 into some ESRI shape files.<br>I'm using PostGIS Dumper (pgsql2shp).<br><br>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.<br><br>I googled around but couldn't find something useful.<br><br>Any help for solving my problem would be highly appreciated,<br><br>thanks in advance,<br><br>Ervin.</div><br><hr>Explore the seven wonders of the world <a href="http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE" target="_blank">Learn more!</a></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>
<br><hr>Explore the seven wonders of the world <a href="http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE" target="_blank">Learn more!</a></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>
<br></div></div><div class="WgoR0d"><hr>Connect to the next generation of MSN Messenger <a href="http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline" target="_blank">Get it now! </a></div>
</div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>