mysql :将表字段类型更新为Clob

Question

我认为mysql中没有Clob类型。我的问题是:这是真的吗？如果是真的(mysql中不存在Clob)，我可以使用什么类型来保存非常长的文本？

Answer 1

TEXT您可以使用TEXT OR BLOB数据类型。

BLOB or TEXT − A field with a maximum length of 65535 characters.
BLOBs are "Binary Large Objects" and are used to store large amounts of binary data, such as images or other types of files. 
Fields defined as TEXT also hold large amounts of data. 
The difference between the two is that the sorts and comparisons on the stored data are case sensitive on BLOBs and are not case sensitive in TEXT fields. 
You do not specify a length with BLOB or TEXT.