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

[Jeff McKenna]

On 12-06-13 10:46 AM, Jukka Rahkonen wrote:
> 
> Next trouble: I would now take the data back from PostGIS into Spatialite (it
> was much faster to do some processing with PostGIS) but the happens again: my
> non-ascii characters are converted to something invalid. I cannot see any
> SQLITECLIENTENCODING option or anything.
> 

It is difficult for me to comment without testing.  I would guess that
you need to use the "-sql" ogr2ogr switch with something like this
command for sqlite: http://www.sqlite.org/pragma.html#pragma_encoding

-jeff


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/