At 11:56 PM +0200 6/27/01, Tobias Eggendorfer wrote:
>Hi,
>
>I suppose I found a bug :-)
>According to LIKE in a SELECT-query is case-insensitive. In fact,
>it is, when using it on varchars. But with a longblod, it is not.
>So if the table has column "test longblob" and there is a colum
>where test is set to "xxxxxxAbcdxxxxx", the query SELECT *
>FROM testtable WHERE test LIKE "%abcd%"; will result in an
>empty set. :-(
>I tried it on MySQL 3.23.36 on a RedHat 7.0 box.
Like is case insensitive _by default_. If either operand is a binary
string, however, it's case sensitive.
You can use ALTER TABLE to convert your column to TEXT if you want it
to be case insensitive.
>
>Regards
>
> Tobias
>
>-------------------------------
>Tobias Eggendorfer
>E-Mail: [EMAIL PROTECTED]
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
