17.10 - Byte Data Types - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-1094-171K
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