15.00 - Integer Data Types - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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

       1

       1

       1

SMALLINT

       2

       2

       2

INTEGER

       4

       4

       4

BIGINT

       8

       8

       8