Question about collations in MySQL?

Have a table with the following structure:

mysql_collations_question_table_structur



It contains the following data:

mysql_collations_question_table_data.png



Do experimental query:

SELECT<br>
LOWER(`md5_upper_bin`),<br>
LOWER(`md5_upper_ge_ci`),<br>
UPPER(`md5_lower_bin`),<br>
UPPER(`md5_lower_ge_ci`) <br>
FROM `qwew`




The result:

mysql_collations_question_experimental_q


Question: why Postfix _bin these fields is ignored in this case? Guided by the man in the MySQL, because you can say that _bin also influences the functions case conversion of string data, so the presence _bin in the name of the comparison must offset the effect of LOWER and UPPER functions. What in practice happens.
October 10th 19 at 14:57
2 answers
October 10th 19 at 14:59
Maybe you need to use
SET NAMES binary
October 10th 19 at 15:01
Guided by the man in the MySQL, because you can say that _bin also influences the functions case conversion of string data, so the presence _bin in the name of the comparison must offset the effect of LOWER and UPPER functions.

Why are you specified for the link says quite the opposite?

Find more questions by tags SQLMySQL