On 09/27/2013 12:48 AM, Anders Karlsson wrote:
Try specifying the utf8_bin collation instead and that will work.
or if you need comparisons to be case insensitive, but still want
to have accented letters be considered different to their base
form and to each other you may want to have a look
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
