Question about collations in MySQL?

0 like 0 dislike
4 views
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
LOWER(`md5_upper_bin`),
LOWER(`md5_upper_ge_ci`),
UPPER(`md5_lower_bin`),
UPPER(`md5_lower_ge_ci`)
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.
by | 4 views

2 Answers

0 like 0 dislike
Maybe you need to use
SET NAMES binary
by
0 like 0 dislike
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?
by

Related questions

0 like 0 dislike
1 answer
asked Apr 9, 2019 by vetsmen
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
110,608 questions
257,186 answers
0 comments
28,644 users