Bennet> MySQL documentation says that CHAR and VARCHAR types are case-insensitive:
Bennet> http://www.mysql.com/doc/C/H/CHAR.html
Bennet> But I have a table with a column of type VARCHAR(255), and if I do a query
Bennet> like
Bennet> select * from user where LOCATE('Bennett', emailaddress) > 0;
Bennet> then the results are computed in a case-SENSITIVE fasion.
This is a bug ; We will fix this in next MySQL release.
Regards,
Monty
---------------------------------------------------------------------
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
