[PHP-DB] How to make it case sensitive?

2001-09-21 Thread Denny Suvanto
I have a web site backup with PHP MySQL. I write a script, so a member can log in into the member area. I build a database for the username, password, and some other information for the member. I set the username (which type is varchar) as the primary key. For the authentication scheme I use :

Re: [PHP-DB] How to make it case sensitive?

2001-09-21 Thread Jason Stechschulte
On Fri, Sep 21, 2001 at 05:02:14PM +0100, Denny Suvanto wrote: The script is just fine until I notice that the username is case insensitive. So, if a member has a username andy he can log in using andy, Andy, aNdY, andY, and so on. I also notice that I can't enter a new member with username

Re: [PHP-DB] How to make it case sensitive?

2001-09-21 Thread David Bullock
On Fri, 21 Sep 2001 14:28:52 -0400, [EMAIL PROTECTED] (Jason Stechschulte) wrote: On Fri, Sep 21, 2001 at 05:02:14PM +0100, Denny Suvanto wrote: The script is just fine until I notice that the username is case insensitive. So, if a member has a username andy he can log in using andy, Andy,