Howto make user name case sensitive?
ingox - November 10, 2008 - 11:19
I'm runnig drupal 5.7 using a mysql database.
The user names are not case sensitive.
For example I cannot create the following users: user and User
How can I force drupal to do that without hacking the user module?
Thank you very much for your help in advance.
Ingo
My first thought is that you
My first thought is that you might be able to make the users table case sensitive. http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
a simple request..but
a simple request..but ....
the devl is not in the mySql, but in the PHP (drupal). I dont think u can get it resolved in a near future.
other ideas?
I have changed mysql to work properly using the following command:
alter table `users` modify `name` VARCHAR(60) COLLATE latin1general_cs;
MySql is working as expected now.
The problem is that drupal does a "LOWER" in all queries.
So it doesn't matter what the database does.
I don't like toh hack the user.module to work the way I want.
Somebody else must have the same problem.
I'm using drupal 5.7.
Is there something different in newer versions of drupal?
I appreciate your help.
Ingo