MySQL case-sensitive search

andyrav · Post by **andyrav** » Tue Aug 25, 2015 10:56 pm

having a problem with case sensitive search
where would i add

define("EW_LIKE_COLLATION_FOR_MYSQL", 'utf8_general_ci', TRUE);

many thanks

danielc · Post by **danielc** » Wed Aug 26, 2015 9:46 am

You can click [Tools]->[Advanced Settings]->[Collation for Like operator (MySQL)] to enter (if you use MySQL), e.g. utf8_bin for case sensitive search. Then, regenerate the script.

Skybound · Post by **Skybound** » Mon Mar 13, 2017 5:49 pm

How do you enable a case insensitive search or even a %LIKE% search?