The CHAR and VARCHAR types are not case sensitive by default , but may be declared as BINARY to make them case sensitive. ENUM , SET , and TEXT columns are not case sensitive. BLOB columns are case sensitive. (See the table in Recipe 4.1.)
Are char variables case-sensitive?
The CHAR and VARCHAR types are not case sensitive by default , but may be declared as BINARY to make them case sensitive. ENUM , SET , and TEXT columns are not case sensitive. BLOB columns are case sensitive. (See the table in Recipe 4.1.)