| Subject | How to store value in different currency ? |
|---|---|
| Author | nathanelrick |
| Post date | 2012-04-09T17:44:02Z |
Hello,
i want to permit user to store their objects with price in their preferred currency. this is not a big problem, but i also want to permit users to search among all the object in their currency
Ex :
i want all object with price > 100 USD or
i want all object with price > 100 EUR
How do you handle this ? actually i store all the value in EUR in the database with a field EUR2CurrencyRate ... and every week i update the value in EUR with the new exchange rate. it's too much intensive as i need to scan every week all the database to update all the value that was not filled in EUR
i want to permit user to store their objects with price in their preferred currency. this is not a big problem, but i also want to permit users to search among all the object in their currency
Ex :
i want all object with price > 100 USD or
i want all object with price > 100 EUR
How do you handle this ? actually i store all the value in EUR in the database with a field EUR2CurrencyRate ... and every week i update the value in EUR with the new exchange rate. it's too much intensive as i need to scan every week all the database to update all the value that was not filled in EUR