[gdal-dev] Launder=yes and Spatialite driver
jukka.rahkonen at mmmtike.fi
Thu Jan 19 05:34:05 EST 2012
Spatialite driver document http://gdal.org/ogr/drv_sqlite.html says about Layer
Creation Option LAUNDER
LAUNDER=yes/no: Controls whether layer and field names will be laundered for
easier use in SQLite. Laundered names will be convered to lower case and some
special characters will be changed to underscores.
What are the special characters which are laundered? It looks like the
Scandinavian characters åäöÅÄÖ are not on the list. Here is a litte Spatialite
database which is created with the -lco LAUNDER=yes option. Attributes names
which åäöÅÄÖ characters does not look the same any longer but they do not have
underscores either. Database can be used with GDAL without problems as it is,
but Spatialite-gui is showing those attribute names as empty.
I solved the problem this time by editing the column names in the source data
but it might be good to know in the future what gets laundered and what not.
More information about the gdal-dev