[gdal-dev] MapInfo TAB with WindowsLatin1 into Spatialite

Luca Sigfrido Percich sigfrido at tiscali.it
Thu Jan 19 09:10:00 EST 2012

Hi Jukka,

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


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

Otherwise try the following workaround, which does not require manual

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


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

More information about the gdal-dev mailing list