What MySQL datatype & attributes should be used to store large amounts of html formatted data?

Question

I'm setting up a database using PHPMyAdmin and many fields will be large chunks of HTML.

What MySQL datatype & attributes should be used for fields that store large amounts of HTML data?

Answer 1

TEXT, MEDIUMTEXT, or LONGTEXT

Answer 2

I would recommend against storing large chunks of HTML (or other text data) in a database. I find that it's often far more useful to store files as files, and put a filename in the database instead.

On the other hand, if you're doing everything through phpMyAdmin, you may not have that option available to you.