Re: [Firebird-devel] INT64 Alias for Numeric( 18, )

[Ann W. H. <aha...@ib...>]

At 09:06 PM 11/18/2002 -0500, Leyne, Sean wrote:
> >
> >     So the mapping NUMERIC(18,0) to BIGINT is an illegal one and must
>be removed until firebird have a INT64 field.

No.  Numerics between 10 and 18 digits are stored as quadwords
which are precisely int64.


>How did Borland manage to claim that NUMERIC( 18, 0) was equivalent to
>64 bit integer?
>(2^63-1 == 9223372036854775807, 19 digits)

Numeric (18, x) is a subset of int64.  They couldn't claim
numeric (19, x) because there are 19 digit numbers that don't
fit.

Regards,

Ann
www.ibphoenix.com
We have answers.