16.10 - Byte Data Types - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
User Guide
Publication ID
B035-1094-161K
Language
English (United States)
BYTE(n): 1 - 64 000 Bytes Fixed (n bytes) (All Platforms)
         Byte 1 Byte 64,000
1  —  64,000
VARBYTE(n): 1 - 64,000 Bytes Variable (  n bytes) (All Platforms)
         Byte 1 Byte 64,000
1  —  64,000
LONG VARBYTE(n): 1 - 64,000 Bytes Fixed (equivalent to VARBYTE (64000) (All Platforms)
         Byte 1 Byte 64,000
1  —  64,000
BLOB(n): 8 bytes - 2,097,088,000 Bytes Variable (All Platforms)
Chunk Bytes 1 - 8 Byte 64,000
1 length 1  —  64,000
length 1  —  64,000
m length 1  —  m

The following table shows the alignment and size for byte types on both platforms.

Data Type Packed64 Size Aligned Row Size Allocated Aligned Row Size
BYTE(n) n 1 n
VARBYTE(n)  n          ≤  n                     ≤   n
LONGVARBYTE(n) ≤ n            n                     ≤   n
BLOB(n) n 1  n