On mercredi 7 juin 2017 13:09:53 CEST Tobias Wendorff wrote: > Am Di, 6.06.2017, 22:11 schrieb Even Rouault: > > Renaming the layers in ArcMap probably fixed the case inconsistency. > > > > Fixed per https://trac.osgeo.org/gdal/ticket/6916 > > I don't know, if .gpkg allows UTF8 characters in column name. > Doesn't lower() introduce problems with UTF8? Some characters might > turn into a different notation? Don't know exactly, just want to > give a hint ;)
Indee from https://sqlite.org/lang_corefunc.html#lower , "The lower(X) function returns a copy of string X with all ASCII characters converted to lower case. The default built-in lower() function works for ASCII characters only." it is not very clear what happens when non ASCII characters are encountered. Little experiment : $ sqlite3 sqlite> select lower('EéE'); eée So apparently it lets non-ASCII UTF-8 characters unchanged, so I think using lower() should be safe Even -- Spatialys - Geospatial professional services http://www.spatialys.com
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user