Geek Answers Handbook

MySql field size for storing email body

I want to save the contents of the email body in MySql. What will be the correct type and size of the field? Can varchar () provide enough memory? Is there an email body length limit?

Thanks in advance.

+5
source share
2 answers

You will need to use blob or text types. There are no restrictions on the length of the email body.

+8
source

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

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

+1
source

More articles:


All Articles