Subject Re: [ib-support] Re: decimal / numeric
Author Claudio Valderrama C.
""csswa"" <csswa@...> wrote in message
news:a8u5f1+7o21@......
> The distinction is something to do with numerics storing the exact=20
> precision/scale and decimals storing *at least* that precision/scale.=20
> (I may have that back to front. No manual within reach right now.)

17) NUMERIC specifies the data type exact numeric, with the decimal
precision and scale specified by the <precision> and <scale>.

18) DECIMAL, specifies the data type exact numeric, with the decimal scale
specified by the <scale> and the implementation-defined decimal precision
equal to or greater than the value of the specified <precision>.

MsSql has true numeric. We only have true decimal.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing