| 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 |