Table 3-11 describes 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. |