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

mysql, sql

Solution

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

- SQLFiddle Demo

Problem

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.

Original source