MYSQL:二进制和 Blob 之间的区别

Question

我试图理解 mysql 数据类型，但我不明白 (Var-)BINARY 数据字段和 BLOB 字段之间的区别。这些类型之间有什么区别？

Answer 1

BLOB 可以有您想要的那么大。

另外，在线阅读MySQL手册:

BLOB and TEXT differ from VARBINARY and VARCHAR in the following ways:

• There is no trailing-space removal for BLOB and TEXT columns when values are stored or retrieved. Before MySQL 5.0.3, this differs from VARBINARY and VARCHAR, for which trailing spaces are removed when values are stored.

• On comparisons, TEXT is space extended to fit the compared object, exactly like CHAR and VARCHAR.

• For indexes on BLOB and TEXT columns, you must specify an index prefix length. For CHAR and VARCHAR, a prefix length is optional. See Section 7.5.1, “Column Indexes”.

• BLOB and TEXT columns cannot have DEFAULT values.