Re: want to compare text input with blob field

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" <smitamanohar@hotmail.com> To: <php-db@lists.php.net> 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 > > >