Question about collations in MySQL?

Question

MySQL

We have a table with the following structure:

It contains the following data:

We make an 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`

We get the result:

Question: why is the _bin postfix for these fields ignored in this case? Based on the MySQL mana, we can say that _bin also affects the string case conversion functions, so the presence of _bin in the name of the comparison should neutralize the effect of the LOWER and UPPER functions. Which doesn't happen in practice.

Answer 1

Maybe you should use
SET NAMES binary

Answer 2

Based on the MySQL mana, you can say that _bin also affects the string case conversion functions, so the presence of _bin in the name of the comparison should neutralize the effect of the LOWER and UPPER functions.

Why is the exact opposite written on the link you specified?