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: [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
