Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

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.