[postgis-users] Illegal Byte Sequence

[Andreas Forø Tollefsen]

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;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110314/7903dd44/attachment.html>