MySql field size for storing email body

I want to store contents of email body into MySql. What would the correct type&size of the field be? Can varchar() provide enough storage size? Is there a limitation in the email body's length?

Thanks in a开发者_JS百科dvance.

You will need to use blob or text types. There is no limit on the length of an email body.

"A BLOB is a binary large object that can hold a variable amount of data"

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