Storing Money in a Database: Why Float Will Cost You
The invoice total is off by one paisa and nobody can find where. Float cannot represent 0.1, so it never could add up. Integer paise or DECIMAL, how to choose, and how to migrate a column that is already wrong.
Read article
