Large-Object Data Types

Large-object data types can store extremely large column values, such as images and documents, independently of the column.
Large-Object Data Type

1 
2.1 TEXT
2.1 BYTE
1?  IN
2.1 TABLE
2.1 blobspace
1 
2.1 BLOB
2.1 CLOB
Element Description Restrictions Syntax
blobspace Name of an existing blobspace Must exist Identifier
The large object data types can be classified in two categories:
  • Simple large objects: TEXT and BYTE
  • Smart large objects: CLOB and BLOB