currency type using FireDAC only saves 2 decimals

I've found this Topic:

Taking a closer look into FireDAC-Methods and how this is used within Aurelius, in my opinion, as Studart Francy already wrote, you should use ftBCD instead of ftCurrency.

Because FireDAC will use SQL_CASH (SQL-OID 790).
For example postgres will then only save 2 digits (PostgreSQL: Documentation: 15: 8.2. Monetary Types)

If you would allow ftBCD for Postgres and use ftBCD for Params instead of ftCurrency, all digits would be stored...

It feels wrong, that you are using numeric for definition of currencies while you are using FireDAC-Money-Type for setting values.

From my point of view you should at least use currency and Moneytype or better BCD with numeric.
Maybe this should be configured using GlobalSettings.

So, as I mentioned in that topic, that's a FireDAC issue, isn't it? If the Currency Delphi type can hold up to 4 digits, it shouldn't be using a Postgres type that only supports 2 digits. Isn't there a global FireDAC type mapping where you can map all ftCurrency types to ftBCD?

As described in documentation:
it is.

But you should be aware of it, implementing your own postgres driver.

1 Like

After testing this in the used FDConnection:

FormatOptions.OwnMapRules := True;
FormatOptions.MapRules.Add(dtBcd, dtCurrency);

everything works fine (for postgres).
Be aware, that it might not work with other databases...

1 Like

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.