I am trying to create a database having "Term of Service" column,
"Version" and "UserID" column. For "TOS" column, the data may have more
than 9000 characters with HTML characters. What type I should use in
this case? BLOB?

usgog (AT) yahoo (DOT) com wrote:
It is likely that this type of data will someday exceed 9000 characters
or any other finite limit of a VARCHAR-like datatype. I'd recommend
going with a text BLOB for variable-length data. More details depends
on which RDBMS brand and version you are using -- see the docs for your
database product for specific characteristics and/or limitations of
BLOB-like datatypes.

Regards,
Bill K.

Thanks. Any limitation for BLOB in MySQL?

usgog (AT) yahoo (DOT) com wrote:
It's all documented here:

http://dev.mysql.com/doc/mysql/en/st...-overview.html

Regards,
Bill K.