Search code examples
sqlcurrencyglobalization

What are the best practices with saving different currencies?

I am working in an application that handles different types of currencies. The application takes the currencies as input and converts them into USD and stores it in the database. Some data processing need to happen which creates issues with inconsistent rounding. I would like to find out the best way to handle store currencies. Is it better to store them in the native currency or store them all in one type like how the application is doing right now and display them in different currencies based on the culture?

Solution

  • I would have a table

    currencies(id, name, sign)

    and I would make sure that there are proper conversions:

    conversions(id, from_currency, to_currency, value)

    You might also want to have a table with conversion histories.