Datatypes

Table 3-11 describes new datatypes.

Table 3-11: New datatypes

Datatype

Description and range

bigint

Fixed-width, signed, 8-byte datatype. Holds whole numbers between –263 and +(263 – 1), inclusive.

unsigned bigint

Unsigned integer datatype. Holds whole numbers between 0 and 18,446,744, 073, 709,551,615, inclusive.

unsigned int

Unsigned integer datatype. Holds whole numbers between 0 and 4,294,967,295, inclusive.

unsigned smallint

Unsigned integer datatype. Holds whole numbers between 0 and 65535, inclusive.

unsigned tinyint

Unsigned integer datatype. Holds whole numbers between 0 and 255, inclusive.

unitext

Variable-width, nullable Unicode datatype coded in UTF-16. Used as text datatype.