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-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to