[Qgis-user] Bug with GeoPackage and Expressions?

[Anita Graser]

Hi Calvin,

28 Jul 2021 21:43:40 C Hamilton <adenaculture at gmail.com>:
> If I use LIKE instead of ILIKE then it works. It is like ILIKE was not implemented for GeoPackage. Can anyone verify this?

Yes, there seems to be no iLike in sqlite:

https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite

And therefore neither in geopackage.

Regards
Anita
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210728/645b94e6/attachment.html>