Database: Currencies By CountryCode?

c# database csv lookup-tables country-codes
001 picture 001 · Feb 22, 2012 · Viewed 7.5k times · Source

Where do I get a list of currencies along with country code?

Example

Code,    Currency Name,  Country,    Format,     Decimal Points,     Currency Regime,    Major Unit,     Minor Unit,     Equivalence,
USD,    US Dollar,  United States,  $#,###.##,  2,  float,  dollar, cents,  100 cents = dollar

REF: http://www.oanda.com/currency/currency-code?srccont=rightnav

<--- this is perfect, however they do not supply a database to download?

Answer

Philip Fourie picture Philip Fourie · Feb 22, 2012

From Wikipedia: http://en.wikipedia.org/wiki/List_of_circulating_currencies

Data from ISO: ISO 4217 currency and funds name and code elements
With the data in XLS and XML format.

Related questions

How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?

Is there a way to compare two DateTime variables in Linq2Sql but to disregard the Time part. The app stores items in the DB and adds a published date. I want to keep the exact time but still be …

Read More
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

I make an outer join and executed successfully in the informix database but I get the following exception in my code: DataTable dt = TeachingLoadDAL.GetCoursesWithEvalState(i, bat); Failed to enable constraints. One or more rows contain values violating non-null, unique, …

Read More
Unable to cast object of type 'System.DBNull' to type 'System.String`

I got the above error in my app. Here is the original code public string GetCustomerNumber(Guid id) { string accountNumber = (string)DBSqlHelperFactory.ExecuteScalar(connectionStringSplendidmyApp, CommandType.StoredProcedure, "GetCustomerNumber", new SqlParameter("@id", id)); return accountNumber.ToString(); } I replaced with public string GetCustomerNumber(…

Read More