Make Ajax Lookup Wizard case insensitive

I had the same issue, the lookup was case sensitive and I needed it to be insensitive. It was the column type in mysql, I had it as varbinary and it needed to be varchar.

Thank you for responding. I verified that the field in question is varchar and even tried explicitly casting it just in case. It didn't make a difference either way. Were you using version 10.91 in your case? At least one user mentioned it changed to be case sensitive in v10.91 where it had not been before. (I have not tested previous versions.)
I also simplified the table query and lookup to a basic example and still it is case sensitive.

Interestingly, the log in the database shows the query using LIKE for the editing and adding, but it uses ILIKE when using that field in the fixed search section on the side. The search works with a case insensitive lookup, verified in the log. So there is a difference between the two.

Did an update inadvertently change that?
Is there a way to force the ILIKE for the lookup?

@lewis The problem I had was in version 11, I can't say if this was the same in V10.91

I'm using MySql/MariaDB and in those the condition LIKE is case insensetive. WHich DB type are you using?

Interesting feature for MySQL. I'm using Postgres which requires ILIKE for case insensitive comparison (unless doing a custom database collation change, which isn't in the plan).

Have you checked your MySQL strings end with ci

screenshot. The ci = case insensitive.

Thanks, MikeUk. I'm actually using Postgres and not MySQL. I can see in the database log that the lookup queries are created using LIKE instead of ILIKE which the search options use. Can I put in a request to either be case-insensitive by default or have an option similar to the search setting checkbox which says "Case-sensitive search"?

In the meantime, is there something I can do with events that can switch LIKE to ILIKE for lookups?