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

[Jan Heckman]

That's
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 '_eme%' AND planstatus NOT LIKE
'voor%' AND planstatus NOT LIKE 'wijzig%' AND planstatus NOT LIKE
'concept%' AND planstatus NOT LIKE 'geconso%' AND planstatus NOT LIKE
'ontwerp%' AND datum > '2006' AND historisch=0 AND digitaalgewaarmerkt LIKE
'ja%' AND dossierstatus <> 'vervallen' AND Naam NOT LIKE '%parke%' AND Naam
NOT LIKE '%paraplu%' AND Naam NOT LIKE '%Parke%' AND Naam NOT LIKE
'%Paraplu%'"

On Thu, Nov 28, 2019 at 4:58 PM Even Rouault <even.rouault at spatialys.com>
wrote:

> On jeudi 28 novembre 2019 16:42:19 CET Jan Heckman wrote:
> > Hi Even, all,
> > Thanks for the fast and helpful response!
> > So, if I need this shortly, I should compile a slightly modified version?
> > I can't see myself giving a true solution to the backward compatibility
> > issue ;)
> > My problem here is not large.
> > The main advantage of caseinsensitive is a compact and accurate query, I
> > was used to seeing if I could just omit the first (capital or not)
> > character.
>
> Try the changeset at https://github.com/OSGeo/gdal/pull/2065
>
> > But I ran into a case where this produced unwanted results and cmdline
> > gave ERROR 1: Destination buffer too small.
>
> Can you share how to reproduce that? That should be fixed
>
> Even
>
> --
> Spatialys - Geospatial professional services
> http://www.spatialys.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20191128/741a635f/attachment-0001.html>