MySQL documentation says that CHAR and VARCHAR types are case-insensitive:
http://www.mysql.com/doc/C/H/CHAR.html
But I have a table with a column of type VARCHAR(255), and if I do a query
like
select * from user where LOCATE('Bennett', emailaddress) > 0;
then the results are computed in a case-SENSITIVE fasion. The above query
gives no results, but if I do
select * from user where LOCATE('bennett', emailaddress) > 0;
then I get a match for each user where the email address contains the
case-sensitive string 'bennett':
--------+----------+--------------------------------+
| ID | username | emailaddress |
+-------+----------+----------+---------------------+
| 48459 | benn1000 | [EMAIL PROTECTED] |
| 3827 | benne100 | [EMAIL PROTECTED] |
| 3828 | benne101 | [EMAIL PROTECTED] |
--------+----------+--------------------------------+
The output of "describe":
mysql> describe user;
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| ID | int(10) unsigned | | PRI | NULL | auto_increment |
| username | varchar(8) | YES | MUL | NULL | |
| emailaddress | varchar(255) | YES | | NULL | |
+--------------+------------------+------+-----+---------+----------------+
Aren't LOCATE and similar functions supposed to be case-insensitive to
begin with? And how do I make them behave that way?
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org
(425) 649 9024
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
