There are no notfications.

Database of currencies

Database of currencies
Initial release:
Current release:
Written in: SQL (UTF-8)
Size: 3010 bytes
Available in:
Licence: Database: ODbL
Database contents: DbCL
Documentation: CC BY 4.0

The database of currencies resource provides currency codes.



The iso_4217 table contains all codes (alphabetic and numeric) of countries and territories considered by the ISO 4217 standard.

Table columns
Name Type Content Reference
code char(2) ISO 4217 alphabetic code.
number char(3) ISO 4217 numeric code.
exponent tinyint(3) Subunit indicator.
country char(2) ISO 3166-1 alpha 2 code.

Directory contents

Directory listing
  • Database of currencies directory
    • Data directory
      • Creation directory
        • iso_4217.sql file
      • Modification directory
        • iso_3166_1.sql file
    • Testing directory
      • iso_4217_iso_3166_1.sql file

Data (directory)

The Data directory contains all SQL scripts that create and modify the databases.

Creation (directory)

iso_4217.sql (file)

The iso_4217.sql file contains the iso_4217 table.

Modification (directory)

iso_3166_1.sql (file)

The iso_3166_1.sql file relates the country column of the iso_4217 table to the alpha_2_code column of the iso_3166_1 table which is provided by the database of countries resource.

Testing (directory)

The Testing directory contains files used for testing the solution during development.


The database of currencies resource by eMedia Intellect is licensed under Open Database License. Any rights in individual contents of the database are licensed under Database Contents License.