[gdal-dev] MapInfo TAB with WindowsLatin1 into Spatialite

[Luca Sigfrido Percich]

Hi Jukka,

for handling similar cases with MapInfo to PostGIS, there is an
environment variable suitable for setting the client character encoding:

export PGCLIENTENCODING=LATIN1

So maybe there is something similar for SQLite? I don't know.

Otherwise try the following workaround, which does not require manual
edits:

. convert the TAB in MIF/MID via ogr2ogr
. encode the .MID file in UTF8 using iconv
. load the resulting MIF/MID file into SQLite

Sig

Il giorno gio, 19/01/2012 alle 09.48 +0000, Jukka Rahkonen ha scritto:
> Hi,
> 
> My MapInfo TAB files have attributes with WindowsLatin1 encoding. Direct
> conversion with ogr2ogr from Mapinfo formta into Spatialite seems to give wrong
> encoding in the Spatialite database. I have not discoverd any direct way for
> changing the encoding into utf-8 with GDAL yet. However, I feel that this way I
> have reached a correct result:
> 
> - Convert from MapInfo into GML with ogr2ogr by using the configuration option
> --config OGR_FORCE_ASCII=no
> - Hand edit the resulting GML file and change it to have encoding="iso-8859-1"
> - Convert this edited GML file into Spatialite.
> 
> Is this the correct way for handling this case? 
> 
> -Jukka Rahkonen-
> 
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev