Re: [patch] Auth to have case sensitive username matching in DB container
| From: | Michael Wallner | 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
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc