In my Yii web application, PostgreSQL Money type variable only support value with $, i.e. $100.
How can I accept value with different currency format. i.e., £100 or €100 ?
In my Yii web application, PostgreSQL Money type variable only support value with $, i.e. $100.
How can I accept value with different currency format. i.e., £100 or €100 ?
Did you read the PostgreSQL docs? It depends on your locale used by the db. I usually store monetary values as integer in the smallest unit, for example cents. This requires filtering user input and formatting before display, but at least I don’t worry about rounding errors, my db is portable and exporting/importing data is easier.