KML Driver rev12157 - spaces in DB Table names generated from KML

[darkblueB]

run the example soc_map_21.kml in ogr2ogr

ogr2ogr -f SQLite soc.sqlite soc_map_21.kml

notice that the output DB has 24 tables, and many of the table names have spaces in them, which confuses the dbms

[warmerdam]

Generally speaking OGR drivers are expected to return layer and field names as they are in the datasource. It is up to output drivers to offer name laundering options if they have restrictions. So I'm reclassifying this as an SQLLite bug report, with the idea that the sqlite driver ought to either quote field/table names so they work even if they have spaces, or it ought to offer a name laundering option.

I am deliberately leaving no milestone and reclassifying as an enhancement.

[Even Rouault]

r22800 /trunk/gdal/ogr/ogrsf_frmts/sqlite/ (ogr_sqlite.h ogrsqlitedatasource.cpp ogrsqlitetablelayer.cpp): SQLite: launder single quote character in table name; properly escape table name if no laundering (#1834)

[Even Rouault]

Attachment has been deleted at request of someone whose private data was exposed into it.