Programming Forums - View Single Post

big_k105 · Mar 26th, 2008, 4:06 PM

I don't know for sure but my guess is that the problem probably has something to do with the info column being a blob. Might want to change that to TEXT or read through MySQL's documention about the blob type and see if there is a way to look through it using like. Not sure how that data type really works. Maybe someone else can recommend something.

http://dev.mysql.com/doc/refman/5.0/en/blob.html

BLOB is for Binary objects so I would recommend changing that column to text.

Mar 26th, 2008, 4:06 PM	#14
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,602 Rep Power: 10	Re: Simple PHP Search Script I don't know for sure but my guess is that the problem probably has something to do with the info column being a blob. Might want to change that to TEXT or read through MySQL's documention about the blob type and see if there is a way to look through it using like. Not sure how that data type really works. Maybe someone else can recommend something. http://dev.mysql.com/doc/refman/5.0/en/blob.html BLOB is for Binary objects so I would recommend changing that column to text. __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.