![]() ![]() ![]() |
Ispirer SQLWays Database Migration Software
BIGINT, UBIGINT, INTEGER, UINTEGER, SMALLINT, USMALLINT, TINYINT and UTINYINT
BIGINT
Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807). Storage size is 8 bytes.
UBIGINT
Unsigned integer (whole number) data from 0 through 18446744073709551615. Storage size is 8 bytes.
INTEGER
Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes.
UINTEGER
Unsigned integer (whole number) data from 0 through 2^32 (4294967295) Storage size is 4 bytes.
SMALLINT
Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767). Storage size is 2 bytes.
USMALLINT
Unsigned integer data from 0 through 2^16 (65535). Storage size is 2 bytes.
TINYINT
Integer data from -2^7 (-128) through 2^7 - 1 (127). Storage size is 1 byte.
UTINYINT
Unsigned integer data from 0 through 255. Storage size is 1 byte.
![]() ![]() ![]() |