Upper Limit for Integer

joesat · Post by **joesat** » Mon Mar 31, 2008 12:51 am

Hi,
I have searched the forums and found out that the upper limit for BigInt is 2,147,483,647.

Can someone please let me know what is the upper limit for Integer?

Thanks!

Cr.Cezon · Post by **Cr.Cezon** » Mon Mar 31, 2008 1:13 am

the upper limit of int32 is 2147483647.
if you need a greater value you can use a double type.
regards,
Cristina.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 31, 2008 1:26 am

The upper limit of BigInt should be 9,223,372,036,854,775,807.

Where did you find that it was different?

The upper limit of TinyInt (int8) is 127 (2^(8-1)-1).

The upper limit of SmallInt (int16) is 32,767 (2^(16-1)-1).

The upper limit of Integer (int32) is 2,147,483,647 (2^(32-1)-1).

The upper limit of BigInt (int64) is 9,223,372,036,854,775,807 (2^(64-1)-1).