Subject RE: [firebird-support] Re: NUMERIC or DECIMAL?
Author Helen Borrie
At 07:59 PM 22/10/2004 -0400, you wrote:

>:: >So my question is...where would you use NUMERIC rather than DECIMAL?
>::
>:: 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?

Precision ranges from 0 to 18. Actually, a NUMERIC(15,2) will be stored as
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 done
>external to FB though, except an occasional sum.

Assuming it's Delphi or thereabouts, I guess you are using BCD fields to
preserve the precision.

./hb