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]>
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
> 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,
> smita.
> _________________________________________________________________
> Send and receive Hotmail on your mobile device:
> --
> PHP Database Mailing List (
> To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to