What's the Best way to store html data in a mysql database?

Question

Should I create a text field or a different type of field? Is there anything else I should know before writing the insertion script? ...Or the select scripts?

Answer 1

You can also use CLOB (Character Large Object). Depends upon the length of data you are storing.

Answer 2

You can use BLOB or TEXT

Answer 3

It's a good idea to store large sections of text in a separate table. This second table only needs an id and a text columns. Do all of your selects on your "meta information" table and then select the text blobs you need from your second table once you have a list of ids.