The error: Importing shapefile (1267 records)... Unable to convert data value to UTF-8 (iconv reports "Illegal byte sequence"). Current encoding is "UTF-8". Try "LATIN1" (Western European), or one of the values described at http://www.postgresql.org/docs/current/static/multibyte.html.
Shapefile import failed. 2011/3/14 Andreas Forø Tollefsen <andrea...@gmail.com> > Hi, > > I am trying to import this shapefile into a database on my new server: > > http://sedac.ciesin.columbia.edu/povmap/downloads/ds_global/imr_shapefile.zip > > While this was no problem on my old server running Windows Vista, i now > have problems on my Ubuntu Server. > My last server had the LC_COLLATE AND LC_CTYPE blank, while the new Linux > has en_US.UTF-8 which seems to create the problems. > I tried creating a new database on the new server with blank COLLATE and > CTYPE, but it would not accept blank. > > Any ideas? > > Thanks, > Andreas > > The old database had the following settings on Enconding: > CREATE DATABASE newpg > WITH OWNER = ----- > ENCODING = 'UTF8' > TABLESPACE = pg_default > LC_COLLATE = '' > LC_CTYPE = '' > CONNECTION LIMIT = -1; > > The database on the new server has the following: > CREATE DATABASE priogrid > WITH OWNER = ----- > ENCODING = 'UTF8' > TABLESPACE = pg_default > LC_COLLATE = 'en_US.UTF-8' > LC_CTYPE = 'en_US.UTF-8' > CONNECTION LIMIT = -1; >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
