Subject Re: [firebird-support] Re: NUMERIC and DECIMAL
Author Ann W. Harrison
Rick Debay wrote:

> Actually, NUMERIC is stored as smallint and DECIMAL as integer.

I don't think so. Each is stored as an integer of sufficient size to
hold specified precision. 4 digits or less, small int, more than r and
less than 9 digits integer, more than 9 and 19 digits int64, and above
that not supported.

V2 may enforce the limitation that a NUMERIC support no more than the
specified precision, but I doubt it. Prior to V2, NUMERIC and DECIMAL
are identical.

Regards,


Ann