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

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact