bigint

Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807). Storage size is 8 bytes.

as stated above, the storage size for the bigint is quie large
but how to cope if my integer data being stored exceed the limitations storage size one day??

Regards,
Elvio

I'm curious. What sorts of exact numbers are you storing where you are concerned that the value might exceed 9 quintillion? (You're not worried about an identity field overflowing, are you?)

The DECIMAL and NUMERIC datatypes offer exact representations to +-10^38.

The FLOAT datatype offers approximate values to roughly 10^308.

Those are pretty big numbers ...



Jeff Mason
Custom Apps, Inc.
www.custom-apps.com