Password field in MySQL database is not case sensitive

Posted on Nov 4, 2011 in Blog

Setting that field collation as Case Sensitive. By default they’re as latin1_sweedish_ci (or whatever character set you’re using) and set it without _ci.

SET TABLE CHARACTER SET latin1 COLLATE latin1_general_cs

The above will be latin1_general_cs = Case Sensitive.