Forum OpenACS Development: Re: lc_monetary and currency_codes table

Collapse
Posted by Torben Brosten on
Oops, looks like I missed something. Brian, Maltes, are you referring to lc_monetary_currency using currency symbols instead of ISO 4217 codes?

If so, perhaps that should be left to acs-lang catalog entries, since most currencies do not have a unique sign: http://en.wikipedia.org/wiki/Currency_sign Or perhaps, the table should be expanded to have a currency sign associated with a locale, realizing that the "$" would have different meaning/values in different locales.

Collapse
Posted by Brian Fenton on
Hi guys,

I don't know enough about ref-currency to comment as to which is preferable, but to answer your questions:
I got the create statement here:
http://cvs.openacs.org/cvs/openacs-4/packages/acs-lang/sql/postgresql/Attic/currency.sql?rev=1.2

hope this helps,
Brian