Have a table with the following structure:
It contains the following data:
Do experimental query:
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.