All Products
Search
Document Center

Overview of large object data types

Last Updated: Jun 18, 2021

The large object (LOB) data types are used to store large amounts of unstructured data, such as texts, images, videos, and spatial data. The LOB data types include binary LOB (BLOB) and character LOB (CLOB).

When you create a table, you can specify tablespaces and storage characteristics for LOB columns or LOB object attributes. The specified tablespaces and storage characteristics can be different from those specified in the table.

ApsaraDB for OceanBase supports the following LOB data types:

Type

Length

Maximum length (characters)

Character set

BLOB

Variable length

48M

BINARY

CLOB

Variable length

48M

UTF8MB4