[gdal-dev] Launder=yes and Spatialite driver

[Jukka Rahkonen]

Hi,

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.

http://latuviitta.org/documents/gdal_launder_test.sqlite

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.

-Jukka Rahkonen-