bigint support

Adaptive Server 15.0 includes the bigint exact numeric datatype.

Table 5-3 shows the range of numbers allowed by the bigint datatype.

Table 5-3: Ranges for big int datatype

Datatype

Range of signed datatypes

bigint

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

As part of the bigint datatype, Adaptive Server now also includes the hextobigint, biginttohex, and count_big functions. For more information, see the Reference Manual: Blocks.