I had a similar question about case-sensitivity, and I was told that MySQL
is automatically case-insensitive! But it depends on your version of MySQL.
Go to the mysql manual and look at chapter 20.16 "Case sensitivity in
searches".
In the newest versions of MySQL, all searches are case-insensitive by
default. To make them case-sensitive however, is a royal pain in the arse.
--
Plutarck
Should be working on something...
...but forgot what it was.
"midget2000x" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> I am writing a PHP script that operates on a MySQL database that uses the
> e-mail address as the primary key. If the e-mail doesn't exist in the
database
> (when a form is submitted), I want to insert a new record. If it does, I
want
> to update the existing record.
>
> How can I make the query that checks if the e-mail exists
case-insensitive? I
> want to avoid users creating another record if they type in their e-mail
in a
> different case.
>
> Thanks!
>
> rory
>
> -----------
> providing the finest in midget technology
>
> --
> PHP General 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]
>
--
PHP General 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]
