For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands The default character set and collation are latin1 an

For 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