ASA SQL Reference
  SQL Data Types
    Numeric data types

BIGINT data type [Numeric]

Function 

Integer requiring 8 bytes of storage.

Syntax 

[ UNSIGNED ] BIGINT

Usage 

The BIGINT data type is an exact numeric data type: its accuracy is preserved after arithmetic operations.

A BIGINT value requires 8 bytes of storage.

The range for signed BIGINT values is -2⁶³ to 2⁶³ - 1, or -9223372036854775808 to 9223372036854775807.

The range for unsigned BIGINT values is 0 to 2⁶⁴ - 1, or 0 to 18446744073709551615.

By default, the data type is signed.

Standards and compatibility 

• SQL/92    Vendor extension.

• Sybase    Not supported in Adaptive Server Enterprise.

See also 

INT or INTEGER data type [Numeric]

TINYINT data type [Numeric]

SMALLINT data type [Numeric]