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: no_spam@stripped
--
Paul DuBois, paul@stripped
