<div dir="ltr"><div dir="ltr">On Wed, Jul 28, 2021 at 2:08 PM C Hamilton <<a href="mailto:adenaculture@gmail.com">adenaculture@gmail.com</a>> wrote:<br></div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">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.</div></blockquote><div><br></div><div>Convert both arguments to upper (or lower) case:</div><div> upper("NAME") like upper( '%Bom%')</div><div><br></div><div> </div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jul 28, 2021 at 8:00 PM Anita Graser <<a href="mailto:anitagraser@gmx.at" target="_blank">anitagraser@gmx.at</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div> <span dir="ltr" style="font-family:sans-serif">Hi Calvin,</span>
<br>
<br> <span dir="ltr" style="font-family:sans-serif">28 Jul 2021 21:43:40 C Hamilton <<a href="mailto:adenaculture@gmail.com" target="_blank">adenaculture@gmail.com</a>>:</span>
<br> <span dir="ltr" style="font-family:sans-serif">> If I use LIKE instead of ILIKE then it works. It is like ILIKE was not implemented for GeoPackage. Can anyone verify this?</span>
<br>
<br> <span dir="ltr" style="font-family:sans-serif">Yes, there seems to be no iLike in sqlite:</span>
<br>
<br> <span dir="ltr" style="font-family:sans-serif"><a href="https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite" target="_blank">https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite</a></span>
<br>
<br> <span dir="ltr" style="font-family:sans-serif">And therefore neither in geopackage.</span>
<br>
<br> <span dir="ltr" style="font-family:sans-serif">Regards</span>
<br> <span dir="ltr" style="font-family:sans-serif">Anita</span>
<br>
</div>
</blockquote></div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr">Richard W. Greenwood, PLS<br><a href="http://www.greenwoodmap.com" target="_blank">www.greenwoodmap.com</a></div></div></div>