Subject | Re: [firebird-support] decimal and numeric |
---|---|
Author | Ann W. Harrison |
Post date | 2005-01-06T18:45:56Z |
bcteh_98 wrote:
the standard numeric (4,2) should have a range of values between -99.99
and +99.99 (4 digits of precision, two digits of scale) while decimal
(4,2) must accept at least that range and can accept an implementation
defined range. Firebird accepts larger numbers in both.
Regards,
Ann
>No. There should be, but Firebird doesn't enforce it. According the
>
> Hi,
>
> What is the difference between Decimal and numeric
> datatype ?
the standard numeric (4,2) should have a range of values between -99.99
and +99.99 (4 digits of precision, two digits of scale) while decimal
(4,2) must accept at least that range and can accept an implementation
defined range. Firebird accepts larger numbers in both.
Regards,
Ann
>