It is a binary colum
-------------------------
-sherzodR
phone: (517) 774-2702
email: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
