ASA SQL Reference
  SQL Data Types
    Numeric data types

INT or INTEGER data type [Numeric]

Function 

Integer requiring 4 bytes of storage.

Syntax 

[ UNSIGNED ] { INT | INTEGER }

Usage 

The INTEGER data type is an exact numeric data type; its accuracy is preserved after arithmetic operations.

If you specify UNSIGNED, the integer can never be assigned a negative number. By default, the data type is signed.

The range for signed integers is -2³¹ to 2³¹  - 1, or -2147483648 to 2147483647.

The range for unsigned integers is 0 to 2³²  - 1, or 0 to 4294967295.

Standards and compatibility 

• SQL/92    Compatible with SQL/92. The UNSIGNED keyword is a vendor extension.

• Sybase    The signed data type is compatible with Adaptive Server Enterprise. Adaptive Server Enterprise does not support the UNSIGNED data type.

See also 

BIGINT data type [Numeric]

TINYINT data type [Numeric]

SMALLINT data type [Numeric]