BLOB Data Type | Data Types and Literals | Teradata Vantage - 17.10 - BLOB Data Type - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

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.