<div dir="ltr">Hi everybody,<div>According to <a href="https://gdal.org/user/ogr_sql_dialect.html">docs</a>, LIKE and ILIKE should be caseinsensitive.</div><div>However, they are not.</div><div>ogr2ogr plangebieden.shp -t_srs EPSG:28992 -dim 2 -spat 45000 405000 140000 485000 WFS:"<a href="http://afnemers.ruimtelijkeplannen.nl/afnemers2012/services">http://afnemers.ruimtelijkeplannen.nl/afnemers2012/services</a>" 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.<br></div><div>Replacing LIKE with ILIKE makes no difference.</div><div>ogr2ogr --version: GDAL 2.3.0dev, released 2017/99/99<br></div><div>Is there a way to use a LIKE like caseinsensitively in an ogr2ogr query?</div><div>Thanks,</div><div>Jan</div></div>