Page 1 of 1

About the upper and lower case letters in username

Posted: Mon Jan 24, 2005 11:24 am
by oskin
We admit in ZM the user with a name "test" is created. If to try to make login with a name "Test" we shall receive successful result, i.e. we shall receive "ZM - Console", but zms it will be completed with an error "ERR [Unable to authenticate user]".
IMHO for solution of this problem enough to make so:
ALTER TABLE Users CHANGE Username Username VARCHAR(32) BINARY NOT NULL default '';

Posted: Mon Jan 24, 2005 12:40 pm
by zoneminder
Hmm, you're right, mysql is case-insensitive in string comparisons, to varying degrees according to version. I never knew that! I'll try your suggestion.

Phil