Chapter 1: New Features in Adaptive Server Version 15.0

Unsigned int support

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. Table 1-2 describes the range of the signed and unsigned versions of these datatypes.

**Table 1-2: Ranges for signed and unsigned datatypes**
Datatype	Range of signed datatypes	Range of unsigned datatypes
bigint	Whole numbers between -2⁶³ and 2⁶³ - 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
int	Whole numbers between -2³¹ and 2³¹ - 1 (-2,147,483,648 and 2,147,483,647), inclusive	Whole numbers between 0 and 4,294,967,295
smallint	Whole numbers between -2¹⁵ and 2¹⁵ -1 (-32,768 and 32,767), inclusive	Whole numbers between 0 and 65535

View this book as PDF