[postgis-users] problem with apostrophe

[Andreas Neumann]

Merci beaucoup - ca marche bien ...

Isn't LATIN1 and ISO-8859-1 the same?

Thanks a lot ...

Andreas

TECHER David wrote:

> Andreas Neumann a écrit :
>
>> [cut]
>>
>> 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
>>
> Hi Andreas
>
> With all french shapefile I'm used to importing in PostGIS, the 
> shapefile are in LATIN1 or LATIN9
>
> Since U are in GNU/Linux U can use iconv or recode
>
> shp2pgsql -DI [shapefile] [table] | iconv -f LATIN1 -t UTF-8 -c | psql 
> [database]
>
>
> shp2pgsql -DI [shapefile] [table] | recode l9..u8 | psql [database] 
> (with l9 as LATIN9 and u8 as UTF-8)
>
>
> Since U understand French have a look on my blog at
>
> for iconv:
>
> http://www.davidgis.fr/blog/index.php?2006/11/24/83-importer-un-shapefile-francais-dans-une-base-encodee-en-utf-8 
> (for iconv)
>
> for recode
>
> http://www.davidgis.fr/blog/index.php?2006/12/09/97-autre-astuce-pour-passer-d-un-shapefile-a-une-base-de-donnees-encode-en-utf-8 
>
>
>     
>
>     
>        
> ___________________________________________________________________________ 
> Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et 
> son interface révolutionnaire.
> http://fr.mail.yahoo.com
> _______________________________________________
> 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/