In MySQL, certain characters are considered the same when performing searches, e.g. 'n' and 'ñ'; unless you specify BINARY in the condition.
Is there a list somewhere of the characters that are considered the same?
MySQL – Which Accented Characters Are Considered the Same?
character-setMySQLutf-8
Related Question
- Mysql – What are the side effects of changing MySQL `character_set_server`
- MySQL – Why SELECT Timeline Differs with Same WHERE Clause and EXPLAIN Plan
- MySQL/MariaDB – Allowed Characters in User Account Names
- MySQL – Remove All Special Characters Without Removing Accented Characters
- Mysql – Which characters are considered “word” characters
- Mysql – One query should be better but I can’t see the performance improvements
- MySQL String Replacement – Replace Part of a String with Known Substring
Best Answer
Case or accent sensitivity behavior is defined by the collation you are using.
The full list of comparable characters in a given collation can be found in collationcharts where you find the MySQL list of collations
If you find your collation in that list you will see a chart of comparable characters.