I just had the same problem!
I converted the blob column to a text column and then the problem went away.
This page may be of use from the MySQL manual:
But I couldn't get their solution to work, so I changed the format of the
column to TEXT and it works fine.
----- Original Message -----
From: "Smita Manohar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 22, 2002 3:51 PM
Subject: [PHP-DB] want to compare text input with blob field
> im using php with mysql 3.23
> in my script im accepting text input and want to compare it with the
> which is of the type blob.
> trying with following query.
> SELECT * from table where fieldname LIKE '% $textinupt %'
> but it is giving case sensitive result bcos the field which im comparing
> with text input is blob.
> what should i do to avoid case sensitive result??? is it required to
> input text also in boob format?? then how to do that??
> thnx and regds,
> Send and receive Hotmail on your mobile device: http://mobile.msn.com
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php