Wednesday, August 31, 2011

MySQL case-insensitive

Surprise! Strings are case-insensitive by default for MySQL.

http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
The default character set and collation are latin1 and latin1_swedish_ci, so nonbinary string comparisons are case insensitive by default.