[postgis-users] problem with apostrophe

[Andreas Neumann]

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,
Andreas

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/