Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Data Types » Numeric data types

FLOAT data type Next Page

INTEGER data type

The INTEGER data type is used to store integers that require 4 bytes of storage.




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.

See also
Standards and compatibility