Hi everybody, According to docs <https://gdal.org/user/ogr_sql_dialect.html>, LIKE and ILIKE should be caseinsensitive. However, they are not. ogr2ogr plangebieden.shp -t_srs EPSG:28992 -dim 2 -spat 45000 405000 140000 485000 WFS:"http://afnemers.ruimtelijkeplannen.nl/afnemers2012/services"; Bestemmingsplangebied -lco ENCODING=UTF-8 -where "BeleidsmatigVerantwoordelijkeOverheid LIKE 'Geme%'" produces empty output. The clue is that LIKE 'geme%' (as in the DB 'gemeente'). does produce output. Replacing LIKE with ILIKE makes no difference. ogr2ogr --version: GDAL 2.3.0dev, released 2017/99/99 Is there a way to use a LIKE like caseinsensitively in an ogr2ogr query? Thanks, Jan
_______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
