MySQL question. VARCHAR(255) the longest

[Anon]

How to make a column in Mysql that is longer than VARCHAR... For example when making a forum or sth. people may send longer messages than 255 characters long.... how to do it...?
THX a lot

P.S. This may be an easy question. Forgive me but I'm just getting started.

[Anon]

Use the BLOB type instead of a VARCHAR.

[Anon]

I've used TEXT in the past. According to the docs the only difference is that searches are case insensitive on TEXT and case sensitive on BLOB.

[Anon]

It says there is an error when I try using anything other than varchar or char....

[pharcyde]

well what's the error? Are you trying to use that field as a key? If so can't do that with blobs