<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:10pt"><div style="font-family: arial,helvetica,sans-serif;"><span>Lars,<br></span></div><div style="font-family: arial,helvetica,sans-serif;"><span><br></span></div><div style="font-family: arial,helvetica,sans-serif;"><span>Looking at the <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">shp2pgsql</span> documentation, it is possible to specify the shape attributes encoding </span><span><span>with the <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">-W</span> parameter.</span></span></div><div style="font-family: arial,helvetica,sans-serif;"> <br></div><div><font style="font-weight:bold;color:rgb(0, 96, 191);font-family:verdana, helvetica, sans-serif;" size="2">IC Carlos Ruiz</font><br><br></div><div style="font-family: Courier New, courier, monaco, monospace,
sans-serif; font-size: 10pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Lars Lingner <gislars+list@googlemail.com><br><b><span style="font-weight: bold;">To:</span></b> "'mapserver-users@lists.osgeo.org'" <mapserver-users@lists.osgeo.org><br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, August 2, 2011 2:45 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [mapserver-users] how does mapserver determine shapefile encoding?<br></font><br>Hello,<br><br>I have a shapefile from which I don't really know the encoding. It might<br>be latin1 or ISO-8559-5. The good thing is, when MapServer is accessing<br>the shapefile, the labels are shown correct.<br>QGis is also displaying everything fine.<br><br>But when I try to convert with shp2pgsql or ogr I get only garbage back.<br>I tried
different source encodings. Since I need the data to be in the<br>database I'm now trying to find out where the problem is.<br><br>I tried converting the data on different systems (Ubuntu, RedHat), with<br>postgis/shp2pgsql from repository as well as self compiled. Same<br>results. Also iconv and recode wasn't a help.<br><br>As I said QGis is displaying everything fine it fails in converting the<br>shapefile too. Opening the dbf in LibreOffice doesn't helped either.<br><br>Finally my (odd) questions are: Why does MapServer do everything right?<br>How is the encoding determined? Can I see somewhere which encoding is<br>used by MapServer?<br><br>Thanks in advance for any pointers.<br><br><br>Lars<br>_______________________________________________<br>mapserver-users mailing list<br><a ymailto="mailto:mapserver-users@lists.osgeo.org" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a
href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br><br><br></div></div></div></body></html>