[postgis-users] Illegal Byte Sequence

[Andreas Forø Tollefsen]

I have no idea why it worked, but importing the shapefile to the new
database using QGIS and Spit worked without problems.
Could it be that QGIS corrects any bad digits in the dbf file before
transmitting?

Andreas

2011/3/14 Andreas Forø Tollefsen <andreasft at gmail.com>

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