[SOLVED] Firebird SQL currency dataype representation
lazarus / 16-Databases

----------------------------------------------------------------------
k1attila1 · 2017-02-10 06:16

Hello

Do somebody know which is the best way to represent Currency datatype
in FireBird 2.5 ?
(How can i substitute missing currency datatype in FB 2.5)

thank you Attila

----------------------------------------------------------------------
Zoran · 2017-02-10 06:20

Use decimal: http://www.firebirdsql.org/file/documentation/reference_m
anuals/fblangref25-en/html/fblangref25-datatypes-
fixedtypes.html#fblangref25-datatypes-decimal

----------------------------------------------------------------------
k1attila1 · 2017-02-10 06:24

Thank you Zoran

And which precison ?

maybe decimal(16,2) or something else ?

thnaks Attila

----------------------------------------------------------------------
k1attila1 · 2017-02-10 06:54

Ok thank you
decimal(16,2) ok
Attila

----------------------------------------------------------------------
Thaddy · 2017-02-10 07:48

For important currency calculations it is better to use 5 instead of
2, because that is the international standard for conversion between
currencies and calculation with currencies. You can then always
display with precision 2, using banker's rounding for the correct
result.
The 5 precision also needs to be rounded using bankers rounding.

If you work with it like that, your application is compliant with
standards in the financial industry.

Summary: store with 5, display with 2, use banker's rounding.