Re: How to make it case sensitive?

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 jpstech@unoh.edu -- I think it's a new feature. Don't tell anyone it was an accident. :-) -- Larry Wall on s/foo/bar/eieio in <10911@jpl-devvax.JPL.NASA.GOV>