Table of ContentsPreviousNext

Ispirer             Ispirer


Ispirer SQLWays Database Migration Software

bigint, int or integer, smallint and tinyint

[unsigned] bigint

Integer (whole number) data. The range for signed bigint values is from -2^63 (-9223372036854775808) through 2^63 - 1 (9223372036854775807). The range for unsigned bigint values is from 0 through 2^64 - 1 (18446744073709551615).

Storage size is 8 bytes. The data type is signed as the default.

[unsigned] int
[unsigned] integer

Integer (whole number) data. The range for signed integer is from -2^31 (-2147483648) through 2^31 - 1 (2147483647). The range for unsigned integer is from 0 through 2^32 - 1 (4294967295).

Storage size is 4 bytes.

[unsigned] smallint

Integer (whole number) data. The range for signed smallint is from -2^15 (-32768) through 2^15 - 1 (32767). The range for unsigned smallint is from 0 through 2^16 - 1 (65535).

Storage size is 2 bytes.

[unsigned] tinyint

Unsigned integer (whole number) data from 0 through 2^8 - 1 (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.