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.