List:General Discussion« Previous MessageNext Message »
From:Colin Faber Date:June 27 2001 11:00pm
Subject:Re: Bug in Like with longblob
View as plain text  
a blob is by definition case sensitive hence 'Binary Large Object' This
is not a bug but by design, If you want a non-Binary field to store
large text objects then you should be using the 'TEXT' data type not the
'BLOB' data type.



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-cfaber=fpsn.net@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