Subject | RE: [firebird-support] Re: NUMERIC or DECIMAL? |
---|---|
Author | Helen Borrie |
Post date | 2004-10-23T00:36:55Z |
At 07:59 PM 22/10/2004 -0400, you wrote:
a NUMERIC(18,0), i.e. a 64-bit integer. Its scale is stored separately.
preserve the precision.
./hb
>:: >So my question is...where would you use NUMERIC rather than DECIMAL?Precision ranges from 0 to 18. Actually, a NUMERIC(15,2) will be stored as
>::
>:: Except at very low precision, no difference.
>
>Aah now you have me piqued. :) I have a LOT of 15, 2's are those low
>precision?
a NUMERIC(18,0), i.e. a 64-bit integer. Its scale is stored separately.
>Actaully Im using this to store monetary values.Fine for USD.
>All mathematics are doneAssuming it's Delphi or thereabouts, I guess you are using BCD fields to
>external to FB though, except an occasional sum.
preserve the precision.
./hb