[gdal-dev] Ogr2ogr from Spatialite into PostGIS stops to non-ASCII character

Jukka Rahkonen jukka.rahkonen at mmmtike.fi
Wed Jun 13 04:58:06 PDT 2012


Hi,

How could I prevent the following problem:

ERROR 1: INSERT command for new feature failed.
ERROR:  invalid byte sequence for encoding "UTF8": 0xc56b

Command: INSERT INTO "test_table" ("wkb_geometry" , "address",
"osoite") VALUES ('0101000020FB0B0000AB1109023B190841634688040C595941'
::GEOMETRY, 'Jurmo ┼kershamn', 8) RETURNING "ogc_fid"
ERROR 1: Terminating translation prematurely after failed
translation of layer test_table (use -skipfailures to skip errors)

I believe that my Spatialite db is in order and uses UTF-8 internally. The
target PostGIS db is also using UTF-8. 
I am on a Windows XP machine with Finnish locale settings.

-Jukka Rahkonen-





More information about the gdal-dev mailing list