Re: Bug in Like with longblob

[Sherzod Ruzmetov <sherzod@xxxxxxxxxxxxx>]

It is a binary colum


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

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

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@xxxxxxxxx
> 
> ---------------------------------------------------------------------
> 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@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail <mysql-unsubscribe-sherzod=ultracgis.com@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


---------------------------------------------------------------------
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-thread77874@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php