Hi All,
What's the best table type for a comments textarea that could be up to 1000 words?
I'm using MySQL 4.1.9.
Tia, Will
Table type for upto 1000 words in a comments field
Moderator: General Moderators
1000 words?
Seeing as words are different lengths, that could be pretty hard to judge.
Perhaps you mean characters? With my tables I choose type TEXT.
Seeing as words are different lengths, that could be pretty hard to judge.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
that may be useful to youA BLOB is a binary large object that can hold a variable amount of data. The four BLOB types, TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB, differ only in the maximum length of the values they can hold.
See Section 11.5, “Column Type Storage Requirements”.
The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, correspond to the four BLOB types and have the same maximum lengths and storage requirements.
BLOB columns are treated as binary strings (byte strings). TEXT columns are treated as non-binary strings (character strings). BLOB columns have no character set, and sorting and comparison is based on the numeric values of the bytes in column values. TEXT columns have a character set, and values are sorted and compared based on the collation of the character set assigned to the column as of MySQL 4.1. Before 4.1, TEXT sorting and comparison are based on the collation of the server character set.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.