Re: [patch] Auth to have case sensitive username matching in DB container
| From: | Daniel Convissor | Date: | Thu, 13 May 2004 12:14:32 +0000 |
| Subject: | Re: [patch] Auth to have case sensitive username matching in DB container | ||
| References: | 1 2 3 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-29200@lists.php.net to get a copy of this message | ||
On Wed, May 12, 2004 at 10:43:14PM -0700, Ian Eure wrote:
> I know that PostgreSQL won't do this, and MySQL only does
> case-insensitive searches if you use LIKE.
MySQL is case insensitive, unless you're searching a BLOB.
mysql> select 'a' = 'A' as t;
+---+
| t |
+---+
| 1 |
+---+
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409