Which data type for HTML? [duplicate]

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
– Fahim Parkar, Commented Aug 21, 2013 at 11:46

amdorra · Accepted Answer · 2013-08-21 11:36:00Z

2

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

answered Aug 21, 2013 at 11:36

1,5549 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin Bean · Accepted Answer · 2013-08-21 11:39:00Z

0

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

answered Aug 21, 2013 at 11:39

39.6k28 gold badges134 silver badges207 bronze badges