<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'><div style="text-align: left;">I tried that solution, but the result is the same as before.<br><br>Maybe I should get rid of those nasty characters before exporting to shape.<br><br>Thank you very much for your help.<br><br>Ervin.<br></div><br><br><br><hr id="EC_stopSpelling">Date: Fri, 18 Jul 2008 13:52:22 +0200<br>From: gabmessner@gmail.com<br>To: postgis-users@postgis.refractions.net<br>Subject: Re: [postgis-users] Postgis to ESRI shape file encoding problem<br><br><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="EC_gmail_quote">2008/7/18 Ervin Ramonllari <<a href="mailto:ervin.ramonllari@hotmail.com">ervin.ramonllari@hotmail.com</a>>:<br><blockquote class="EC_gmail_quote" style="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="EC_Wj3C7c">
<br>From: <a href="mailto:gabmessner@gmail.com">gabmessner@gmail.com</a><br>To: <a href="mailto:postgis-users@postgis.refractions.net">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">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">gabmessner@gmail.com</a><br>
To: <a href="mailto:postgis-users@postgis.refractions.net">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">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">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">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="EC_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>
<br /><hr />Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! <a href='http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us' target='_new'>Try it!</a></body>
</html>