money
Rietta's posts on storing currency correctly in PostgreSQL and MySQL, including which data types to use.
Subscribe to money posts via RSS
06/04/2019
Best Data Type to store Money in MySQL?
by Alex Piechowski
MySQL has no MONEY type. Use DECIMAL(13,2) for most currency, or DECIMAL(13,4) when GAAP compliance needs four places, and see the max value each can hold.
01/28/2019
Storing currency in PostgreSQL
by Christopher Choi
There are different ways we can store currency in PostgreSQL, this blog post will cover the money and numeric type.