Subject | Re: [ib-support] Re: decimal / numeric |
---|---|
Author | Claudio Valderrama C. |
Post date | 2002-04-09T07:59:46Z |
""csswa"" <csswa@...> wrote in message
news:a8u5f1+7o21@......
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
news:a8u5f1+7o21@......
> The distinction is something to do with numerics storing the exact=2017) NUMERIC specifies the data type exact numeric, with the decimal
> precision/scale and decimals storing *at least* that precision/scale.=20
> (I may have that back to front. No manual within reach right now.)
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