Funny,
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:
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
But I couldn't get their solution to work, so I changed the format of the
column to TEXT and it works fine.
Cheers
stuart
- 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
> hii
> im using php with mysql 3.23
> in my script im accepting text input and want to compare it with the
field
> 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
convert
> input text also in boob format?? then how to do that??
>
> thnx and regds,
> smita.
>
>
>
> _
> 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