Home / Language & Localization / Currencies

Currencies

A standardized currency reference dataset intended for use in web and application development. It includes stable currency identifiers and ISO 4217 codes, with a schema designed for predictable querying and reuse. This dataset is suitable for common use cases such as pricing, payments, financial reporting, and localization across different frameworks and storage formats.

Rows 168

Last updated 2025-12-23 19:21:57

Download

View raw SQL

currencies.sql (8 KB)

Preview

id	currency_code	currency_name	currency_symbol
1	AFA	Afghan Afghani	؋
2	ALL	Albanian Lek	Lek
3	DZD	Algerian Dinar	دج
4	AOA	Angolan Kwanza	Kz
5	ARS	Argentine Peso	$
6	AMD	Armenian Dram	֏
7	AWG	Aruban Florin	ƒ
8	AUD	Australian Dollar	$
9	AZN	Azerbaijani Manat	m
10	BSD	Bahamian Dollar	B$
11	BHD	Bahraini Dinar	.د.ب
12	BDT	Bangladeshi Taka	৳
13	BBD	Barbadian Dollar	Bds$
14	BYR	Belarusian Ruble	Br
15	BEF	Belgian Franc	fr
16	BZD	Belize Dollar	$
17	BMD	Bermudan Dollar	$
18	BTN	Bhutanese Ngultrum	Nu.
19	BTC	Bitcoin	฿
20	BOB	Bolivian Boliviano	Bs.
21	BAM	Bosnia-Herzegovina Convertible Mark	KM
22	BWP	Botswanan Pula	P
23	BRL	Brazilian Real	R$
24	GBP	British Pound Sterling	£
25	BND	Brunei Dollar	B$

Raw SQL

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `currencies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `currencies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `currency_code` varchar(3) NOT NULL,
  `currency_name` varchar(50) NOT NULL,
  `currency_symbol` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `currencies` WRITE;
/*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
INSERT INTO `currencies` VALUES (1,'AFA','Afghan Afghani','؋'),(2,'ALL','Albanian Lek','Lek'),(3,'DZD','Algerian Dinar','دج'),(4,'AOA','Angolan Kwanza','Kz'),(5,'ARS','Argentine Peso','$'),(6,'AMD','Armenian Dram','֏'),(7,'AWG','Aruban Florin','ƒ'),(8,'AUD','Australian Dollar','$'),(9,'AZN','Azerbaijani Manat','m'),(10,'BSD','Bahamian Dollar','B$'),(11,'BHD','Bahraini Dinar','.د.ب'),(12,'BDT','Bangladeshi Taka','৳'),(13,'BBD','Barbadian Dollar','Bds$'),(14,'BYR','Belarusian Ruble','Br'),(15,'BEF','Belgian Franc','fr'),(16,'BZD','Belize Dollar','$'),(17,'BMD','Bermudan Dollar','$'),(18,'BTN','Bhutanese Ngultrum','Nu.'),(19,'BTC','Bitcoin','฿'),(20,'BOB','Bolivian Boliviano','Bs.'),(21,'BAM','Bosnia-Herzegovina Convertible Mark','KM'),(22,'BWP','Botswanan Pula','P'),(23,'BRL','Brazilian Real','R$'),(24,'GBP','British Pound Sterling','£'),(25,'BND','Brunei Dollar','B$'),(26,'BGN','Bulgarian Lev','Лв.'),(27,'BIF','Burundian Franc','FBu'),(28,'KHR','Cambodian Riel','KHR'),(29,'CAD','Canadian Dollar','$'),(30,'CVE','Cape Verdean Escudo','$'),(31,'KYD','Cayman Islands Dollar','$'),(32,'XOF','CFA Franc BCEAO','CFA'),(33,'XAF','CFA Franc BEAC','FCFA'),(34,'XPF','CFP Franc','₣'),(35,'CLP','Chilean Peso','$'),(36,'CLF','Chilean Unit of Account','CLF'),(37,'CNY','Chinese Yuan','¥'),(38,'COP','Colombian Peso','$'),(39,'KMF','Comorian Franc','CF'),(40,'CDF','Congolese Franc','FC'),(41,'CRC','Costa Rican Colón','₡'),(42,'HRK','Croatian Kuna','kn'),(43,'CUC','Cuban Convertible Peso','$, CUC'),(44,'CZK','Czech Republic Koruna','Kč'),(45,'DKK','Danish Krone','Kr.'),(46,'DJF','Djiboutian Franc','Fdj'),(47,'DOP','Dominican Peso','$'),(48,'XCD','East Caribbean Dollar','$'),(49,'EGP','Egyptian Pound','ج.م'),(50,'ERN','Eritrean Nakfa','Nfk'),(51,'EEK','Estonian Kroon','kr'),(52,'ETB','Ethiopian Birr','Nkf'),(53,'EUR','Euro','€'),(54,'FKP','Falkland Islands Pound','£'),(55,'FJD','Fijian Dollar','FJ$'),(56,'GMD','Gambian Dalasi','D'),(57,'GEL','Georgian Lari','ლ'),(58,'DEM','German Mark','DM'),(59,'GHS','Ghanaian Cedi','GH₵'),(60,'GIP','Gibraltar Pound','£'),(61,'GRD','Greek Drachma','₯, Δρχ, Δρ'),(62,'GTQ','Guatemalan Quetzal','Q'),(63,'GNF','Guinean Franc','FG'),(64,'GYD','Guyanaese Dollar','$'),(65,'HTG','Haitian Gourde','G'),(66,'HNL','Honduran Lempira','L'),(67,'HKD','Hong Kong Dollar','$'),(68,'HUF','Hungarian Forint','Ft'),(69,'ISK','Icelandic Króna','kr'),(70,'INR','Indian Rupee','₹'),(71,'IDR','Indonesian Rupiah','Rp'),(72,'IRR','Iranian Rial','﷼'),(73,'IQD','Iraqi Dinar','د.ع'),(74,'ILS','Israeli New Sheqel','₪'),(75,'ITL','Italian Lira','L,£'),(76,'JMD','Jamaican Dollar','J$'),(77,'JPY','Japanese Yen','¥'),(78,'JOD','Jordanian Dinar','ا.د'),(79,'KZT','Kazakhstani Tenge','лв'),(80,'KES','Kenyan Shilling','KSh'),(81,'KWD','Kuwaiti Dinar','ك.د'),(82,'KGS','Kyrgystani Som','лв'),(83,'LAK','Laotian Kip','₭'),(84,'LVL','Latvian Lats','Ls'),(85,'LBP','Lebanese Pound','£'),(86,'LSL','Lesotho Loti','L'),(87,'LRD','Liberian Dollar','$'),(88,'LYD','Libyan Dinar','د.ل'),(89,'LTC','Litecoin','Ł'),(90,'LTL','Lithuanian Litas','Lt'),(91,'MOP','Macanese Pataca','$'),(92,'MKD','Macedonian Denar','ден'),(93,'MGA','Malagasy Ariary','Ar'),(94,'MWK','Malawian Kwacha','MK'),(95,'MYR','Malaysian Ringgit','RM'),(96,'MVR','Maldivian Rufiyaa','Rf'),(97,'MRO','Mauritanian Ouguiya','MRU'),(98,'MUR','Mauritian Rupee','₨'),(99,'MXN','Mexican Peso','$'),(100,'MDL','Moldovan Leu','L'),(101,'MNT','Mongolian Tugrik','₮'),(102,'MAD','Moroccan Dirham','MAD'),(103,'MZM','Mozambican Metical','MT'),(104,'MMK','Myanmar Kyat','K'),(105,'NAD','Namibian Dollar','$'),(106,'NPR','Nepalese Rupee','₨'),(107,'ANG','Netherlands Antillean Guilder','ƒ'),(108,'TWD','New Taiwan Dollar','$'),(109,'NZD','New Zealand Dollar','$'),(110,'NIO','Nicaraguan Córdoba','C$'),(111,'NGN','Nigerian Naira','₦'),(112,'KPW','North Korean Won','₩'),(113,'NOK','Norwegian Krone','kr'),(114,'OMR','Omani Rial','.ع.ر'),(115,'PKR','Pakistani Rupee','₨'),(116,'PAB','Panamanian Balboa','B/.'),(117,'PGK','Papua New Guinean Kina','K'),(118,'PYG','Paraguayan Guarani','₲'),(119,'PEN','Peruvian Nuevo Sol','S/.'),(120,'PHP','Philippine Peso','₱'),(121,'PLN','Polish Zloty','zł'),(122,'QAR','Qatari Rial','ق.ر'),(123,'RON','Romanian Leu','lei'),(124,'RUB','Russian Ruble','₽'),(125,'RWF','Rwandan Franc','FRw'),(126,'SVC','Salvadoran Colón','₡'),(127,'WST','Samoan Tala','SAT'),(128,'STD','São Tomé and Príncipe Dobra','Db'),(129,'SAR','Saudi Riyal','﷼'),(130,'RSD','Serbian Dinar','din'),(131,'SCR','Seychellois Rupee','SRe'),(132,'SLL','Sierra Leonean Leone','Le'),(133,'SGD','Singapore Dollar','$'),(134,'SKK','Slovak Koruna','Sk'),(135,'SBD','Solomon Islands Dollar','Si$'),(136,'SOS','Somali Shilling','Sh.so.'),(137,'ZAR','South African Rand','R'),(138,'KRW','South Korean Won','₩'),(139,'SSP','South Sudanese Pound','£'),(140,'XDR','Special Drawing Rights','SDR'),(141,'LKR','Sri Lankan Rupee','Rs'),(142,'SHP','St. Helena Pound','£'),(143,'SDG','Sudanese Pound','.س.ج'),(144,'SRD','Surinamese Dollar','$'),(145,'SZL','Swazi Lilangeni','E'),(146,'SEK','Swedish Krona','kr'),(147,'CHF','Swiss Franc','CHf'),(148,'SYP','Syrian Pound','LS'),(149,'TJS','Tajikistani Somoni','SM'),(150,'TZS','Tanzanian Shilling','TSh'),(151,'THB','Thai Baht','฿'),(152,'TOP','Tongan Pa\'anga','$'),(153,'TTD','Trinidad & Tobago Dollar','$'),(154,'TND','Tunisian Dinar','ت.د'),(155,'TRY','Turkish Lira','₺'),(156,'TMT','Turkmenistani Manat','T'),(157,'UGX','Ugandan Shilling','USh'),(158,'UAH','Ukrainian Hryvnia','₴'),(159,'AED','United Arab Emirates Dirham','إ.د'),(160,'UYU','Uruguayan Peso','$'),(161,'USD','US Dollar','$'),(162,'UZS','Uzbekistan Som','лв'),(163,'VUV','Vanuatu Vatu','VT'),(164,'VEF','Venezuelan BolÃvar','Bs'),(165,'VND','Vietnamese Dong','₫'),(166,'YER','Yemeni Rial','﷼'),(167,'ZMK','Zambian Kwacha','ZK'),(168,'ZWL','Zimbabwean dollar','$');
/*!40000 ALTER TABLE `currencies` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Categories

Popular

Currencies

Download

Preview

Raw SQL