Subject RE: [firebird-support] BIGINT Vs Numeric(18,0)
Author Alan McDonald
> 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

I'm aware of the signing taking a bit but no matter how many times I count
the digits in this number I get 19
9,223,372,036,854,775,807
I can also put -9,223,372,036,854,775,807 in the field.
If I put 9,223,372,036,854,775,808 - I get an exception as expected but it's
still 19.
Alan