Hello, there are online store. For example, two currencies - the dollar and the Euro. One of the currency is current, that is, one in which all prices on the website. For example, in a database recorded all the prices in dollars and you need to change the current currency to the Euro. It is unlikely prices in the database will have to be recalculated every time when you change the current currency? As usual kept the price of goods? Assume that prices in the default currency, a currency for another price displayed in the output view converted to another currency to the current rate?
Good to avoid unnecessary errors to keep one base price.
And the table with the current exchange rate.
And when prompted to convert.
Otherwise, let's say you have 5 currencies. And a lot of goods.
You change the price tag at the time of the price change something and children not so dead, are not associated database where each other chaotically mismatched.
jaycee answered on March 23rd 20 at 19:07
keep a separate table with the current course, and in the product currency which made its cost. The rest - rendering
adolf_Leannon93 answered on March 23rd 20 at 19:09
Yes, you can store default currency, and display to the user depending on the selected currency (on the way to calculate it at the current rate)
And can be stored in the database of prices in several currencies.
In my opinion, roughly the same options from the point of view of correctness)