is that true if "password" is char or varchar as well? Or only for text fields? | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		gizzlon on May 25, 2012 \| parent \| context \| favorite \| on: Diablo 3 bug report: "Passwords not case-sensitive... is that true if "password" is char or varchar as well? Or only for text fields?

tszming on May 25, 2012 [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact