and collation is “utf8_general_ci”.
And that’s the answer. If you’re using
utf8_general_ci (actually it applies to all
utf_..._[ci|cs]) collation then diacritics are bypassed in comarison, thus:
SELECT "e" = "é" AND "O" = "Ó" AND "ä" = "a"
1. Indexes also use collation.
If you want to distinguish between
a then use
utf8_bin collation (keep in mind that it also distinguish between uppercase and lowercase characters).
By the way name and age don’t guarantee any uniqueness.