Unsigned Integer Datatype Support

Adaptive Server 15.0 supports unsigned integer datatypes.

These unsigned integer datatypes allow you to extend the range of the positive numbers for the existing integer types without increasing the required storage size. That is, the signed versions of these datatypes extend both in the negative direction and the positive direction (for example, from -32 to +32). However, the unsigned versions extend only in the positive direction. This is the range for signed and unsigned datatypes:


Range of signed datatypes

Range of unsigned datatypes


Whole numbers between -263 and 263 - 1 (from -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807, inclusive

Whole numbers between 0 and 18,446,744,073,709,551,615


Whole numbers between -231 and 231 - 1 (-2,147,483,648 and 2,147,483,647), inclusive

Whole numbers between 0 and 4,294,967,295


Whole numbers between -215 and 215 -1 (-32,768 and 32,767), inclusive

Whole numbers between 0 and 65535