We are working with currency and handle currencies from various countries. As a result, we may work with currencies that require no decimal values, two decimal places, three, sometimes four.
We also store taxes that are derived from individual items, and we usually store them with higher precision than the currency specifies (eg: taxes for Canadian dollars would be stored to 4 decimal places)
What would be an appropriate way to store these values? I have read that many people store them as integers in the lowest denomination (eg: dollars would be stored in cents), but the 4-decimal taxes would not work out very well.
Asked by MxLDevs
(359 rep)
Feb 5, 2014, 07:57 PM