How to store money in int in database?

Question

Database design

I wondered how to store money in the database. Most often, it is advised to store in int (multiply, divide by 100)

But if you replenish the account by 0.333 dollars, when multiplied by 100 we get 33.3

As I understand it, in order to make a universal option for all currencies, you need to multiply by 100000000 to take into account even bitcoin?

Answer 1

Most often it is advised to store in int

What bad advice. Any DBMS allows you to specify the precision of the number after the decimal point, use this.
If I'm not mistaken, for all the money in the world, two decimal places are enough. Bitcoin is not money. )))
Well, of course, if the program has a specific type of exchange rates, then the accuracy is considered up to 4 and up to 6 characters. What for all to dump in a heap and to do the general-purpose decision. Decide what exactly your program will store.
PS it is clear how to store monetary values. But it is better to work with them as decimal fractions, and not as floating point numbers. At least on the backend, at least on the front.

Answer 2

Answer here

Answer 3

Yes. everything is correct to translate into pennies