Thanks everyone for that explanation. This does complicate the ability to set an expression filter in a plugin when it depends on the data source type. I'm not sure what to do about that.
Regards, Calvin On Wed, Jul 28, 2021 at 8:00 PM Anita Graser <anitagra...@gmx.at> wrote: > Hi Calvin, > > 28 Jul 2021 21:43:40 C Hamilton <adenacult...@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 >
_______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer