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
> "Andy", "anDY", and so on as they will duplicate the
> existing "andy". Is this the natural behaviour of
> MySQL or is there anyway to make it case sensitive?
> I'm using PHP 4.0.6 & MySQL 3.23.39.

You have to make the column case sensitive, binary will accomplish this.
Something like:

username varchar(20) binary
Jason Stechschulte
I think it's a new feature.  Don't tell anyone it was an accident.  :-)
         -- Larry Wall on s/foo/bar/eieio in <[EMAIL PROTECTED]>

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to