|
The INTEGER data type is used to store integers that require 4 bytes of storage.
[ UNSIGNED ] INTEGER
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 -231 to 231 - 1, or -2147483648 to 2147483647.
The range for unsigned integers is 0 to 232 - 1, or 0 to 4294967295.
INTEGER can also be specified as INT. Regardless of which syntax is used, the data type is described as INTEGER.
SQL/2003 Compatible with SQL/2003. The UNSIGNED keyword is a vendor extension.