About the upper and lower case letters in username

[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 '';

[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