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.)
Read moreCan you use == for char?
Yes, char is just like any other primitive type, you can just compare them by == .
Read more