Which data type for HTML?

Question

I would like to store HTML in my database, what field type would you recommend?

VarChar
Blob
Text

The HTML will vary in length depending on the row.

what kind of html files are you going to store? I meant small files or large files like forum? — Fahim Parkar, Aug 21 '13 at 11:46

score 2 · Answer 1 · answered Aug 21 '13 at 11:36

2

for this task i recommend storing your html in files and in the database use varchar(255) for file path.

answered Aug 21 '13 at 11:36

amdorra

score 0 · Answer 2 · answered Aug 21 '13 at 11:39

0

Text, since HTML is, after all, text. What’s it’s MIME type? text/html.

answered Aug 21 '13 at 11:39

Martin Bean

2 Answers2