mysql - Why "n" is included when I search for "ñ"?

Question

I have a problem. When I have this code SELECT FIRST_NAME FROM CONTACT WHERE FIRST_NAME LIKE '%ñ%' why is it returning all FIRST_NAME that has n without ñ. Im expecting only those that have ñ. Thanks in advance.

Answer 1

SELECT FIRST_NAME 
FROM CONTACT 
WHERE FIRST_NAME LIKE '%ñ%' COLLATE utf8_spanish_ci 

• SQLFiddle Demo

Answer 2

Try to use a BINARY operator to compare strings in binary way -

SELECT FIRST_NAME FROM CONTACT WHERE FIRST_NAME LIKE BINARY '%ñ%'