MySQL case-sensitive search
Posted: 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
having a problem with case sensitive search
where would i add
define("EW_LIKE_COLLATION_FOR_MYSQL", 'utf8_general_ci', TRUE);
many thanks
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.
How do you enable a case insensitive search or even a %LIKE% search?