Ticket #2221 (closed defect: fixed)
OGR SQL limits table name and column name character set
| Reported by: | trastourf | Owned by: | chaitanya |
|---|---|---|---|
| Priority: | normal | Milestone: | 1.9.0 |
| Component: | OGR_SF | Version: | unspecified |
| Severity: | normal | Keywords: | SQL |
| Cc: | tamas, warmerdam |
Description
The OGR SQL implementation limits table names and column names to letters, digits and [.+-_*].
For example, with mysql with the table "Départs" wich as a column 'NomDépart?' the command :
ogrinfo MySQL:test,host=localhost -sql "select NomDépart? from départs"
works fine. With an equivalent shape (départs.shp), i can do :
ogrinfo départs départs
this works for the filename, but i can't do :
ogrinfo départs.shp -sql "select NomDépart? from Départs" INFO: Open of `départs.shp'
using driver `ESRI Shapefile' successful.
ERROR 1: SQL: Missing comma after column NomD in SELECT statement.

