List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 27 2001 11:10pm
Subject:Re: Bug in Like with longblob
View as plain text  
At 11:56 PM +0200 6/27/01, Tobias Eggendorfer wrote:
>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.

>   Tobias
>Tobias Eggendorfer
>E-Mail: no_spam@stripped

Paul DuBois, paul@stripped
Bug in Like with longblobTobias Eggendorfer27 Jun
  • Re: Bug in Like with longblobColin Faber28 Jun
  • Re: Bug in Like with longblobWerner Stuerenburg28 Jun
  • Re: Bug in Like with longblobPaul DuBois28 Jun
  • Re: Bug in Like with longblobSherzod Ruzmetov28 Jun