Integer Data Types
|
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 |
|
|
|
|
SMALLINT |
|
|
|
|
INTEGER |
|
|
|
|
BIGINT |
|
|
|