Great. Yes, I am running the trunk version. Thank you Nicklas for this information.
Andreas 2011/3/14 Nicklas Avén <nicklas.a...@jordogskog.no> > Hallo Andreas > > May I guess you are running the trunk version. > > I think it is related to tichet #808 > > http://trac.osgeo.org/postgis/ticket/808 > > One workaround is described in the ticket by creating the .sql file > without any encoding parameters and then change the first row of the sql > file to > SET CLIENT_ENCODING TO LATIN1; > before running it in psql > > Another workaround is using an older skp2pgsql to create the sql-file. > PostGIS will load it in PostGIS 2 format anyway. > > HTH > > Nicklas > > On Mon, 2011-03-14 at 11:11 +0100, Andreas Forø Tollefsen wrote: > > 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 > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
