- Sun Mar 04, 2018 5:51 pm
#813506
I am connecting the suggest control to a Postgres database and have noticed that it is performing the queries case sensitive.
Looking at the logs on the database it is doing the following query
Has anyone else had this issue?
Thanks.
Looking at the logs on the database it is doing the following query
Code: Select all
To be case insensitive it should use ILIKE rather than LIKE.Select field1,field2 FROM table1 LIKE "%search%"
Has anyone else had this issue?
Thanks.