All Products
Search
Document Center

Large-object data types

Last Updated: Jun 18, 2021

The following table lists the large-object (LOB) data types.

Type

Length

Maximum storage length (bytes)

Character set

TINYTEXT

Variable

256

UTF8MB4

TINYBLOB

Variable

256

BINARY

TEXT

Variable

65536 (64 KB)

UTF8MB4

BLOB

Variable

65536 (64 KB)

BINARY

MEDIUMTEXT

Variable

16777216 (16 MB)

UTF8MB4

MEDIUMBLOB

Variable

16777216 (16 MB)

BINARY

LONGTEXT

Variable

50331648 (48 MB)

UTF8MB4

LONGBLOB

Variable

50331648 (48 MB)

BINARY