MySql field size for storing email body

Question

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 advance.

Answer 1

"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

Answer 2

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