How come MySQL is not differentiating between these characters?
SELECT text_id, us, de, es, fr
FROM texts
WHERE us = fr;
Results in matching here. Notice the difference in the scene vs scène
text_id us es de fr
-- -- -- -
Hi,
I wold expect this NOT to match.
This should be because the fields you are comparing are utf8_general_ci,
this collation groups characters in 'classes' so that all variants of what
are considered to belong to the same character type, are put in that class.
Equality comparison is done
That is because of the collation. It's the collations that determines
character equality. I can't tell what the collation is in your case for
the columns us, es, de, es and fr. Also, that you match character sets
in different columns is usually not a good idea, unless you have a good
reason