3 ms·
is that true if "password" is char or varchar as well? Or only for text fields?
by gizzlon 14y ago
is that true if "password" is char or varchar as well? Or only for text fields?
- tszming 14y agoFor nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands The default character set and collation are latin1 and latin1_swedish_ci, so nonbinary string comparisons are case insensitive by default. http://dev.mysql.com/doc/refman/5.1/en/case-sensitivity.html http://dev.mysql.com/doc/refman/5.1/en/case-sensitivity.html