INTEGER data type

The INTEGER data type stores integers that require 4 bytes of storage.

Syntax

[ UNSIGNED ] INTEGER

Remarks

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 INTEGER values is -2³¹ to 2³¹ - 1, or -2147483648 to 2147483647.

The range for UNSIGNED INTEGER values is 0 to 2³² - 1, or 0 to 4294967295.

When converting a string to an INTEGER, leading and trailing spaces are removed. If the leading character is +, it is ignored. If the leading character is -, the remaining digits are interpreted as a negative number. Leading 0 characters are skipped, and the remaining characters are converted to an integer value. An error is returned if the value is out of the valid range for the destination data type, if the string contains illegal characters, or if the string cannot be decoded as an integer value.

Standards and compatibility

SQL/2008 The INTEGER type is a core feature of the SQL/2008 standard. The UNSIGNED keyword is a vendor extension.
MySQL The UNSIGNED keyword may follow INTEGER.

Discuss this page in DocCommentXchange.