Martijn Tonies wrote:

> Hi,
>
>
>>I have my currency fields defined to be a NUMERIC(18,6), but I have
>>precision problems.
>>
>>If I enter this value: -654646 FB stores this: -654646,000000000116
>>Is there any way of avoiding this?
>
>
> Yes, use a dialect 3 database.
>
>
>>What is the best format for currency values?
>
>
> Numeric, in dialect 3.

And what about DECIMAL ? Could be used also ? Why NUMERIC is better for
currency then DECIMAL ?


Regards
Boguslaw Brandys