Chapter 12. Currency Codes
ISO 4217 is the three-letter international standard currency code. You will see it used in newspapers for the current exchange rates, in banking, and on airline and international train tickets.
The first two letters of the code are the two letters of ISO 3166-1 country and the third is usually the initial of the currency itself.
Lots of countries use the same name for their currency, but they have no relationship to each other, as with the U.S. dollar and the Canadian dollar. Sometimes the same currency symbol is used; some currencies have no special symbol as do the U.S. dollar ($), yen (¥), euro (€), and British pound (£) signs.
If a currency is revalued, the currency code’s last letter is changed to distinguish it from ...

Get Joe Celko's Data, Measurements and Standards in SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.