Table of ContentsPreviousNext

Ispirer             Ispirer


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.


Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.