List:General Discussion« Previous MessageNext Message »
From:Sherzod Ruzmetov Date:June 28 2001 12:58am
Subject:Re: Bug in Like with longblob
View as plain text  
It is a binary colum


-------------------------
-sherzodR

phone: (517) 774-2702
email: sherzodr@stripped

On Wed, 27 Jun 2001, 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.
> 
> Regards
> 
>   Tobias
> 
> -------------------------------
> Tobias Eggendorfer
> E-Mail: no_spam@stripped
> 
> ---------------------------------------------------------------------
> 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 <mysql-thread77856@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-sherzod=ultracgis.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

Thread
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