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 (
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:
Maximum length (characters)