Question about collations in MySQL?

Have a table with the following structure:





It contains the following data:





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:




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.