[postgis-users] problem with apostrophe

Andreas Neumann neumann at karto.baug.ethz.ch
Tue Jan 16 05:27:03 PST 2007

Thank you for the information Armin.

Yes, most shapefiles are created on Windows, since there is no good ESRI 
support for other platforms anyway.

This helps,

Armin Burger wrote:

> Andreas
> as far as I know shapefiles created with ESRI products on Windows use 
> Win1252 encoding, which is virtually the same as ISO-8859-1 (LATIN1). 
> Probably LATIN1 is also the default for other shape libraries.
> With shp2pgsql you can also use -W "LATIN1" to create the output in UTF.
> armin
>> Do you have an idea how I can find out what encoding my shapefile 
>> uses? In the Postgis DB I use UTF-8, but my shapefile doesn't seem to 
>> use UTF-8. At least it fails if I use UTF-8 as an encoding during 
>> conversion process. I have no idea how to find out what encoding the 
>> shapefile uses. I used ISO-8859-1 during conversion. It seems to work 
>> fine, but it is just a guess encoding that I use now.
>> Thanks,
>> Andreas
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Andreas Neumann
Institute of Cartography
ETH Zurich
Wolfgang-Paulistrasse 15
CH-8093  Zurich, Switzerland

Phone: ++41-44-633 3031, Fax: ++41-44-633 1153
e-mail: neumann at karto.baug.ethz.ch
www: http://www.carto.net/neumann/
SVG.Open: http://www.svgopen.org/
Carto.net: http://www.carto.net/

More information about the postgis-users mailing list