Question: are sql string comparison case sensitive?
Answer: In summary, comparisons are case sensitive if they involve a binary literal string or string expression, or a CHAR BINARY , VARCHAR BINARY , or BLOB column. Comparisons are not case sensitive if they involve only non-binary literal strings or string expressions, or CHAR , VARCHAR , ENUM , SET , or TEXT columns.