SELECT first_name, last_name FROM users u WHERE MATCH(u.first_name, u.last_name) AGAINST ('+áééxcv*' IN BOOLEAN MODE);
I am trying to get the result where first_name of the record is áééxcv (latin chars). I am getting other records in the results starting with charcter "a" (normal "a") but not the expected one.
I get the correct result when I run query:
SELECT first_name, last_name FROM users u u.first_name = 'áééxcv';
Even though MATCH... Against is working as expected in case of normal English characters but not with latin characters.
DB has charset/collation: utf8mb4/utf8mb4_unicode_ci
users table collation: utf8mb4_unicode_ci