Subject RE: [firebird-support] Re: NUMERIC and DECIMAL
Author Rick Debay
Sorry, I meant to explain that the original example switched the Numeric
and Decimal sizes for low precisions.
Numeric will be placed in a smallint if the number of digits will fit.
Decimal will never be smaller than an integer.

-----Original Message-----
[] On Behalf Of Ann W. Harrison
Sent: Tuesday, October 04, 2005 12:02 PM
Subject: Re: [firebird-support] Re: NUMERIC and DECIMAL

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.