Hacker News new | ask | show | jobs
by benjaminoakes 199 days ago
Don't many financial transactions in US dollars get stored as integers anyway? The number of pennies, in other words.

Then just convert to dollars with a decimal place when needing to display, etc.

I recall this being pretty normal regardless of what database you use.

1 comments

A lot of times they are converted to BigInt and then stored as strings so different languages don't mess with the real value