[postgis-users] converting to postgis

[Birgit Laggner]

Hi Farouk,

I always use a workaround in order to convert a shp file with special 
characters in its attribute table into UTF-8 encoding: I open the shp 
file's dbf in some calculation software (e.g. OpenOffice) and save it as 
an csv with encoding UTF-8. Then I open the csv and save it again as a 
dbf under a new name. Then, I exchange the old dbf by the new one (don't 
forget to change the name to, so it does match the shp file name) and 
the shp file gets imported into the postgis database without problems.

There are hopefully more elegant solutions, but for shp-import of only a 
few files, it's ok...

Regards,

Birgit.

Am 29.04.2011 10:32, schrieb farouk azzouhri:
> Hello,
> I converted an Access database (contains two fields X and Y) in a .shp 
> file it's ok, but when I wanted to convert the .shp into a postgis 
> database ( using the shp2pgsql-gui.exe ) it gives me the following 
> message:
>
> Unable to convert field name to UTF-8 (iconv reports "Illegal byte 
> sequence"). Current encoding is "UTF-8". Try "latin1 " (Western 
> European), One Of The gold values ​​at 
> http://www.postgresql.org/docs/current/static/multibyte.html Described.
> Shapefile import failed.
>
> how I'm going to do ??
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110429/be62450f/attachment.html>