Hi,

At April 16, 2004, 05:31, Alan McDonald wrote:

> We graduated from having to declare numeric(18,0) to declaring BIGINT.
> Maybe a dumb question but can someone tell me why BIGINT actually takes 19
> places? how did we get another place or why wasn't it numeric(19,0)?

Why do you say 19 places? Do you have an actual BIGINT number that is
19 places? If you simply mean 2^64 gives a 19 digit number, then it
would be true if BIGINT was an unsigned 64-bit integer. But it's a
signed 64-bit integer, so it's 2^63 + 1 bit for the sign, which gives
an 18 digit number with the sign.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)