BYTEINT: 1 Byte (All Platforms) | |
---|---|
Bit 0 | Bits 1 - 7 |
Sign | -128 — +127 |
SMALLINT: 2 Bytes (All Platforms) | |
---|---|
Bit 0 | Bits 1 - 15 |
Sign | -32,768 — +32,767 |
INTEGER: 4 Bytes (All Platforms) | |
---|---|
Bit 0 | Bits 1 - 31 |
Sign | -2,147,483,648 — +2,147,483,647 |
BIGINT: 8 Bytes (All Platforms) | |
---|---|
Bit 0 | Bits 1 - 63 |
Sign | -9,223,372,036,854,775,808 — +9,223,372,036,854,775,807 |
The following table indicates the alignment requirements for each of the true integer numeric data types and their respective sizes on packed64 and aligned row format systems:
Data Type | Alignment | Packed64 Size (bytes) | Aligned Row Format\ Size (bytes) |
---|---|---|---|
BYTEINT | 1 | 1 | 1 |
SMALLINT | 2 | 2 | 2 |
INTEGER | 4 | 4 | 4 |
BIGINT | 8 | 8 | 8 |