[postgis-users] Illegal Byte Sequence

[Nicklas Avén]

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 <andreasft at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users