MySQL string case sensitivity

I just learned that MySQL's varchar type is case-insensitive by default, and the last space is ignored. C.5.5.1.CaseSensitivityinStringSearchesmysqlSELECTaA;

I just learned that MySQL's varchar type is case-insensitive by default, and the last space is ignored. C.5.5.1. Case Sensitivity in String Searches mysql SELECT 'A' = 'a';-1 solution is to use the BINARY operator 10.1.7.7. the BINARY Operator mysql select binary 'A' = 'a';-0 mysql

I just learned that MySQL's varchar type is case-insensitive by default, and the last space is ignored. C.5.5.1. Case Sensitivity in String Searches

Mysql> SELECT 'A' = 'a';-> 1

The solution is to use The BINARY Operator 10.1.7.7. The BINARY Operator

Mysql> select binary 'A' = 'a';-> 0 mysql> SELECT 'A' = 'a '; -> 1 mysql> select binary 'A' = 'a';-> 0

Original article address: MySQL string is case sensitive. Thank you for sharing it with me.