Hi list ! I had to export a bunch of data from postgis to shapefile (using pgsql2shp), but unfortunately I did this without changing my client-encoding. The destination application does not like the shapefiles the way they are, and all special characters are unreadable ("Ã(c)" instead of "é" for instance). The export was quite painfull (a lot of time and some manual work), and I was wondering whether there would be a simple way to import the shapefiles into postgis, and then re-export them with the correct encoding (LATIN1, AFAICT) ?Thanks for any hint on this !
Iconv may help, I think, converting shapefile encoding into target db encoding: shp2pgsql -dDI TRONCON_ROUTE.SHP troncon_route | iconv -f LATIN1 -t UTF-8 | psql routing as seen on David techer's pgRouting tutorial (http://www.davidgis.fr/documentation/win32/html/apa.html) Nicolas _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
