[gdal-dev] ogr2ogr (I)LIKE not caseINsensitive

[Jan Heckman]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20191128/f7224d6c/attachment.html>