use ILIKE instead of LIKE for case-insensitive searches

diff --git a/PLC/Filter.py b/PLC/Filter.py
index 520c6ff..ad412e1 100644 (file)
--- a/PLC/Filter.py
+++ b/PLC/Filter.py
@@ -176,7 +176,7 @@ class Filter(Parameter, dict):
                         value = "NULL"
                     elif isinstance(value, StringTypes) and \
                             (value.find("*") > -1 or value.find("%") > -1):
-                        operator = "LIKE"
+                        operator = "ILIKE"
                         # insert *** in pattern instead of either * or %
                         # we dont use % as requests are likely to %-expansion later on
                         # actual replacement to % done in PostgreSQL.py