paperdarwin/nats1.sql

Created February 7, 2014 18:39

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/paperdarwin/8868949.js"></script>
Save paperdarwin/8868949 to your computer and use it in GitHub Desktop.

Download ZIP

nats username field is not case sensitive

Raw

SELECT * FROM member WHERE username = 'williaml'

Author

paperdarwin commented Feb 7, 2014

this matches both "Williaml" and "william1"

the problem is, if both user is owned by two different people from two different sites, and the other one is inactive already, the active user is being unintentionally flagged as inactive.

though this is a known issue in VARCHAR type of MySQL
http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

i think NATS should make the username field to have BINARY, VARBINARY, BLOB
to make it case-sensitive.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment