BLOB and TEXT Data Types

Description

A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types are

• TINYBLOB,

• ,

• , and

• .

These differ only in the maximum length of the values they can hold.

The TEXT types are

• ,

• ,

• , and

• .

These correspond to the four BLOB types and have the same maximum lengths and .

BLOB and TEXT columns can have a DEFAULT value.

Note

It is possible to set a unique index on columns that use the BLOB or TEXT data types.

See Also

_{This page is licensed: GPLv2, originally from}