[mapserver-users] ASCII -> UTF-8 convert problems for importing (GIS) data

[Jacolin Yves]

Le Friday 18 April 2008 16:31:01 Stefan Schwarzer, vous avez écrit :
> Hi there,
>
> hmm.... I have a shapefile, which has some unorthodox characters (Ç,
> ì, ...). Now, when importing the file (via shp2pgsql) into postgres,
> it complains about it not being UTF-8 (my database has that format).
>
> So, how can I convert either the dbf file or than in a later stage the
> created text file from (I guess) ASCII into UTF-8?
>
> Thanks for any hints,
>
> Stef_______________________________________________

Hi,

You have an option for shp2pgsql (-W I think) to tell shp2pgsql to convert 
your data into this encoding:

-W <encoding> Specify the character encoding of Shape's
     attribute column. (default : "ASCII")

Y.
-- 
Yves Jacolin
---
http://softlibre.gloobe.org