Re: [patch] Auth to have case sensitive username matching in DB container

From: Date: Thu, 13 May 2004 18:27:26 +0000
Subject: Re: [patch] Auth to have case sensitive username matching in DB container
References: 1 2  Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-29204@lists.php.net to get a copy of this message
Hi Ian Eure, you wrote: > What version? What type is your username column? I can't reproduce this > behavior with a simple SELECT: > > mysql> select * from user where User = 'iEUre'; > Empty set (0.00 sec) > mysql> select * from user where User = 'ieure'; > ... > 2 rows in set (0.00 sec) Well, you query the mysql database where the column User is explicitely set to BINARY. > I mean that I don't think it breaks backwards compatibility. I mean, it > obviously /does/ break it, but I believe that it's correcting broken > behavior, and should be allowed. But having the username case match is, i > think, a reasonable thing to do. I'd say it's rather a thing to discuss thouroughly. > Though I suspect that your problem has rather more to do with your database > than Auth itself. Yes, he should make his column BINARY if he wants case-sensitive matching. Regards, -- Michael - < mike(@)php.net >

Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
« previous php.pear.dev (#29204) next »