SQLite, which is the underneath database engine for GeoPackage, doesn't
support ILIKE. The SQLite LIKE operator is actually case insensitive for
ASCII characters. See paragraph 5 "The LIKE, GLOB, REGEXP, and MATCH
operators" of https://www.sqlite.org/lang_expr.html
Le 28/07/2021 à 21:43, C Ham
I think I found a bug and was wondering if someone could verify this. I am
on Windows 10 and tried this with both QGIS 3.16.9 and 3.20.1.
I tried the following filter expression on the Natural Earth data set
ne_10m_populated_places (
https://www.naturalearthdata.com/http//www.naturalearthdata.com/