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