BLOB Data Type | Data Types and Literals | Teradata Vantage - BLOB Data Type - Teradata Vantage - Analytics Database

Represents a large binary string of raw bytes. A binary large object (BLOB) column can store binary objects, such as graphics, video clips, files, and documents.

ANSI Compliance

BLOB is ANSI SQL:2011 compliant.

Syntax

{ BINARY LARGE OBJECT | BLOB }
  [ ( n [ K | M | G ] ) ]
  [ attribute [...] ]

Syntax Elements

n

The number of bytes to allocate for the BLOB column. The maximum number of bytes is 2097088000, which is the default if n is not specified.

K

n is specified in kilobytes (KB). When K is specified, n cannot exceed 2047937.

M

n is specified in megabytes (Mb). When M is specified, n cannot exceed 1999.

G

n is specified in gigabytes (GB). When G is specified, n must be 1.

attribute

Appropriate data type, column storage, or column constraint attributes.

A BLOB column supports the following attributes:

• NOT NULL
• FORMAT
• TITLE

For more information on NOT NULL, see Default Value Control Phrases. For details on FORMAT and TITLE, see Data Type Formats and Format Phrases.