Subject Re: Currency Types
Author mmenaz
--- In IBObjects@y..., "George Hugo" <georgehg@u...> wrote:
> Hi list.
> What is the best type to use as a currency type!
> I use everething as Double Precision.
> I´ll need to make matematical e financial calcs.
> I´m using te rigth type??
I usually use NUMERIC(15,2), but to get precision you have to use a dialect=
3 database, so this type of columns are stored as saled integers. If you ha=
ve a dialect 1 database, they are stored as double precisions, that is not a=
s good as scaled integers (you will have some rounding problems).
Read about this in Ib6 documentation.
Marco Menardi