Subject | Re: [firebird-support] Re: NUMERIC and DECIMAL |
---|---|
Author | Ann W. Harrison |
Post date | 2005-10-04T16:01:31Z |
Rick Debay wrote:
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
> 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