Skip to content

Instantly share code, notes, and snippets.

@voskobovich
Last active November 25, 2024 18:36
Show Gist options
  • Save voskobovich/537b2000108e4781f70b to your computer and use it in GitHub Desktop.
Save voskobovich/537b2000108e4781f70b to your computer and use it in GitHub Desktop.
List of most currency ISO code and symbol format in SQL.
DROP TABLE currency;
-- Create table variable
CREATE TABLE currency (
name VARCHAR(20),
code VARCHAR(3),
symbol VARCHAR(5)
);
ALTER TABLE currency CONVERT TO CHARACTER SET utf8;
-- Insert currency records
INSERT INTO currency (name, code, symbol) VALUES ('Leke', 'ALL', 'Lek');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'USD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Afghanis', 'AFN', '؋');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'ARS', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Guilders', 'AWG', 'ƒ');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'AUD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('New Manats', 'AZN', 'ман');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BSD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BBD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Rubles', 'BYR', 'p.');
INSERT INTO currency (name, code, symbol) VALUES ('Euro', 'EUR', '€');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BZD', 'BZ$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BMD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Bolivianos', 'BOB', '$b');
INSERT INTO currency (name, code, symbol) VALUES ('Convertible Marka', 'BAM', 'KM');
INSERT INTO currency (name, code, symbol) VALUES ('Pula', 'BWP', 'P');
INSERT INTO currency (name, code, symbol) VALUES ('Leva', 'BGN', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Reais', 'BRL', 'R$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'GBP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BND', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Riels', 'KHR', '៛');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'CAD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'KYD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'CLP', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Yuan Renminbi', 'CNY', '¥');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'COP', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Colón', 'CRC', '₡');
INSERT INTO currency (name, code, symbol) VALUES ('Kuna', 'HRK', 'kn');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'CUP', '₱');
INSERT INTO currency (name, code, symbol) VALUES ('Koruny', 'CZK', 'Kč');
INSERT INTO currency (name, code, symbol) VALUES ('Kroner', 'DKK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'DOP ', 'RD$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'XCD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'EGP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Colones', 'SVC', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'FKP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'FJD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Cedis', 'GHC', '¢');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'GIP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Quetzales', 'GTQ', 'Q');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'GGP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'GYD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Lempiras', 'HNL', 'L');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'HKD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Forint', 'HUF', 'Ft');
INSERT INTO currency (name, code, symbol) VALUES ('Kronur', 'ISK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'INR', 'Rp');
INSERT INTO currency (name, code, symbol) VALUES ('Rupiahs', 'IDR', 'Rp');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'IRR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'IMP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('New Shekels', 'ILS', '₪');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'JMD', 'J$');
INSERT INTO currency (name, code, symbol) VALUES ('Yen', 'JPY', '¥');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'JEP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Tenge', 'KZT', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Won', 'KPW', '₩');
INSERT INTO currency (name, code, symbol) VALUES ('Won', 'KRW', '₩');
INSERT INTO currency (name, code, symbol) VALUES ('Soms', 'KGS', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Kips', 'LAK', '₭');
INSERT INTO currency (name, code, symbol) VALUES ('Lati', 'LVL', 'Ls');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'LBP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'LRD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Switzerland Francs', 'CHF', 'CHF');
INSERT INTO currency (name, code, symbol) VALUES ('Litai', 'LTL', 'Lt');
INSERT INTO currency (name, code, symbol) VALUES ('Denars', 'MKD', 'ден');
INSERT INTO currency (name, code, symbol) VALUES ('Ringgits', 'MYR', 'RM');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'MUR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'MXN', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Tugriks', 'MNT', '₮');
INSERT INTO currency (name, code, symbol) VALUES ('Meticais', 'MZN', 'MT');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'NAD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'NPR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Guilders', 'ANG', 'ƒ');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'NZD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Cordobas', 'NIO', 'C$');
INSERT INTO currency (name, code, symbol) VALUES ('Nairas', 'NGN', '₦');
INSERT INTO currency (name, code, symbol) VALUES ('Krone', 'NOK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'OMR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'PKR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Balboa', 'PAB', 'B/.');
INSERT INTO currency (name, code, symbol) VALUES ('Guarani', 'PYG', 'Gs');
INSERT INTO currency (name, code, symbol) VALUES ('Nuevos Soles', 'PEN', 'S/.');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'PHP', 'Php');
INSERT INTO currency (name, code, symbol) VALUES ('Zlotych', 'PLN', 'zł');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'QAR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('New Lei', 'RON', 'lei');
INSERT INTO currency (name, code, symbol) VALUES ('Rubles', 'RUB', 'руб');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'SHP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Riyals', 'SAR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Dinars', 'RSD', 'Дин.');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'SCR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'SGD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'SBD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Shillings', 'SOS', 'S');
INSERT INTO currency (name, code, symbol) VALUES ('Rand', 'ZAR', 'R');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'LKR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Kronor', 'SEK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'SRD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'SYP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('New Dollars', 'TWD', 'NT$');
INSERT INTO currency (name, code, symbol) VALUES ('Baht', 'THB', '฿');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'TTD', 'TT$');
INSERT INTO currency (name, code, symbol) VALUES ('Lira', 'TRY', '₺');
INSERT INTO currency (name, code, symbol) VALUES ('Liras', 'TRL', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'TVD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Hryvnia', 'UAH', '₴');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'UYU', '$U');
INSERT INTO currency (name, code, symbol) VALUES ('Sums', 'UZS', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Bolivares Fuertes', 'VEF', 'Bs');
INSERT INTO currency (name, code, symbol) VALUES ('Dong', 'VND', '₫');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'YER', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Zimbabwe Dollars', 'ZWD', 'Z$');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'INR', '₹');
-- Select values from table
SELECT * FROM currency;
@Klaubinho
Copy link

Thanks for that Dude!

@bc170202293
Copy link

Thank you for helping

@SonjaSimeonova
Copy link

Thanks a lot

@skobak
Copy link

skobak commented Jan 25, 2019

Big thanks, maybe it's better to use relevant Varchar size for columns:
CREATE TABLE currency ( name VARCHAR(20), code VARCHAR(3), symbol VARCHAR(5) );

@deankal
Copy link

deankal commented Jul 29, 2019

Thank you this is useful, but your handling of Unicode characters isn't correct for SQL Server.

The symbol column needs to be an NVARCHAR type, and the character string literals in the insert values list needs to be preceded with an "N", ie N'$'. Sample below. Without this, the 'New Manats',' AZN','ман') is returned as "???".

set nocount on
declare @Currency as table(
name VARCHAR(100),
code VARCHAR(100),
symbol NVARCHAR(100)
);
-- Insert currency records

INSERT INTO @Currency (name, code, symbol) VALUES ('Leke',' ALL',N'Lek')
INSERT INTO @Currency (name, code, symbol) VALUES ('Dollars',' USD',N'$')
INSERT INTO @Currency (name, code, symbol) VALUES ('Afghanis',' AFN',N'؋')

@smuralimohan
Copy link

Thanks brother.

@eminsr
Copy link

eminsr commented Aug 29, 2019

TRY needs an update,
INSERT INTO currency (name, code, symbol) VALUES ('Lira', 'TRY', '₺');

Thanks.

@netdjw
Copy link

netdjw commented Nov 15, 2019

Thank you!

@yordanjose
Copy link

-- Create table variable
CREATE TABLE currency (
name VARCHAR(100),
code VARCHAR(100),
symbol VARCHAR(100)
);

-- Insert currency records
INSERT INTO currency(name,code,symbol) VALUES ('Leke', 'ALL', 'Lek'),('Dollars', 'USD', '$'),('Afghanis', 'AFN', '؋'),('Pesos', 'ARS', '$'),('Guilders', 'AWG', 'ƒ'),('Dollars', 'AUD', '$'),('New Manats', 'AZN', 'ман'),('Dollars', 'BSD', '$'),('Dollars', 'BBD', '$'),('Rubles', 'BYR', 'p.'),('Euro', 'EUR', '€'),('Dollars', 'BZD', 'BZ$'),('Dollars', 'BMD', '$'),('Bolivianos', 'BOB', '$b'),('Convertible Marka', 'BAM', 'KM'),('Pula', 'BWP', 'P'),('Leva', 'BGN', 'лв'),('Reais', 'BRL', 'R$'),('Pounds', 'GBP', '£'),('Dollars', 'BND', '$'),('Riels', 'KHR', '៛'),('Dollars', 'CAD', '$'),('Dollars', 'KYD', '$'),('Pesos', 'CLP', '$'),('Yuan Renminbi', 'CNY', '¥'),('Pesos', 'COP', '$'),('Colón', 'CRC', '₡'),('Kuna', 'HRK', 'kn'),('Pesos', 'CUP', '₱'),('Koruny', 'CZK', 'Kč'),('Kroner', 'DKK', 'kr'),('Pesos', 'DOP ', 'RD$'),('Dollars', 'XCD', '$'),('Pounds', 'EGP', '£'),('Colones', 'SVC', '$'),('Pounds', 'FKP', '£'),('Dollars', 'FJD', '$'),('Cedis', 'GHC', '¢'),('Pounds', 'GIP', '£'),('Quetzales', 'GTQ', 'Q'),('Pounds', 'GGP', '£'),('Dollars', 'GYD', '$'),('Lempiras', 'HNL', 'L'),('Dollars', 'HKD', '$'),('Forint', 'HUF', 'Ft'),('Kronur', 'ISK', 'kr'),('Rupees', 'INR', 'Rp'),('Rupiahs', 'IDR', 'Rp'),('Rials', 'IRR', '﷼'),('Pounds', 'IMP', '£'),('New Shekels', 'ILS', '₪'),('Dollars', 'JMD', 'J$'),('Yen', 'JPY', '¥'),('Pounds', 'JEP', '£'),('Tenge', 'KZT', 'лв'),('Won', 'KPW', '₩'),('Won', 'KRW', '₩'),('Soms', 'KGS', 'лв'),('Kips', 'LAK', '₭'),('Lati', 'LVL', 'Ls'),('Pounds', 'LBP', '£'),('Dollars', 'LRD', '$'),('Switzerland Francs', 'CHF', 'CHF'),('Litai', 'LTL', 'Lt'),('Denars', 'MKD', 'ден'),('Ringgits', 'MYR', 'RM'),('Rupees', 'MUR', '₨'),('Pesos', 'MXN', '$'),('Tugriks', 'MNT', '₮'),('Meticais', 'MZN', 'MT'),('Dollars', 'NAD', '$'),('Rupees', 'NPR', '₨'),('Guilders', 'ANG', 'ƒ'),('Dollars', 'NZD', '$'),('Cordobas', 'NIO', 'C$'),('Nairas', 'NGN', '₦'),('Krone', 'NOK', 'kr'),('Rials', 'OMR', '﷼'),('Rupees', 'PKR', '₨'),('Balboa', 'PAB', 'B/.'),('Guarani', 'PYG', 'Gs'),('Nuevos Soles', 'PEN', 'S/.'),('Pesos', 'PHP', 'Php'),('Zlotych', 'PLN', 'zł'),('Rials', 'QAR', '﷼'),('New Lei', 'RON', 'lei'),('Rubles', 'RUB', 'руб'),('Pounds', 'SHP', '£'),('Riyals', 'SAR', '﷼'),('Dinars', 'RSD', 'Дин.'),('Rupees', 'SCR', '₨'),('Dollars', 'SGD', '$'),('Dollars', 'SBD', '$'),('Shillings', 'SOS', 'S'),('Rand', 'ZAR', 'R'),('Rupees', 'LKR', '₨'),('Kronor', 'SEK', 'kr'),('Dollars', 'SRD', '$'),('Pounds', 'SYP', '£'),('New Dollars', 'TWD', 'NT$'),('Baht', 'THB', '฿'),('Dollars', 'TTD', 'TT$'),('Lira', 'TRY', 'TL'),('Liras', 'TRL', '£'),('Dollars', 'TVD', '$'),('Hryvnia', 'UAH', '₴'),('Pesos', 'UYU', '$U'),('Sums', 'UZS', 'лв'),('Bolivares Fuertes', 'VEF', 'Bs'),('Dong', 'VND', '₫'),('Rials', 'YER', '﷼'),('Zimbabwe Dollars', 'ZWD', 'Z$');

-- Select values from table
SELECT * FROM currency;

@yordanjose
Copy link

Gracias!!!

@mohitesachin217
Copy link

@rakeshmaity271
Copy link

Thank You so much

@rakeshmaity271
Copy link

If you got any error like utf8 then run below query

ALTER TABLE currency CONVERT TO CHARACTER SET utf8;

@rahulshibu
Copy link

Indian Currency INR's symbol is wrong in the above.
Please update the below
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'INR', '₹');

@shereifsrf
Copy link

shereifsrf commented Jun 27, 2020

CREATE TABLE currency (
name NVARCHAR(20),
code NVARCHAR(3),
symbol NVARCHAR(5)
);

INSERT INTO currency VALUES ('Leke', 'ALL', N'Lek');
INSERT INTO currency VALUES ('Dollars', 'USD', N'$');
INSERT INTO currency VALUES ('Afghanis', 'AFN', N'؋');
INSERT INTO currency VALUES ('Pesos', 'ARS', N'$');
INSERT INTO currency VALUES ('Guilders', 'AWG', N'ƒ');
INSERT INTO currency VALUES ('Dollars', 'AUD', N'$');
INSERT INTO currency VALUES ('New Manats', 'AZN', N'ман');
INSERT INTO currency VALUES ('Dollars', 'BSD', N'$');
INSERT INTO currency VALUES ('Dollars', 'BBD', N'$');
INSERT INTO currency VALUES ('Rubles', 'BYR', N'p.');
INSERT INTO currency VALUES ('Euro', 'EUR', N'€');
INSERT INTO currency VALUES ('Dollars', 'BZD', N'BZ$');
INSERT INTO currency VALUES ('Dollars', 'BMD', N'$');
INSERT INTO currency VALUES ('Bolivianos', 'BOB', N'$b');
INSERT INTO currency VALUES ('Convertible Marka', N'BAM', N'KM');
INSERT INTO currency VALUES ('Pula', 'BWP', N'P');
INSERT INTO currency VALUES ('Leva', 'BGN', N'лв');
INSERT INTO currency VALUES ('Reais', 'BRL', N'R$');
INSERT INTO currency VALUES ('Pounds', 'GBP', N'£');
INSERT INTO currency VALUES ('Dollars', 'BND', N'$');
INSERT INTO currency VALUES ('Riels', 'KHR', N'៛');
INSERT INTO currency VALUES ('Dollars', 'CAD', N'$');
INSERT INTO currency VALUES ('Dollars', 'KYD', N'$');
INSERT INTO currency VALUES ('Pesos', 'CLP', N'$');
INSERT INTO currency VALUES ('Yuan Renminbi', N'CNY', N'¥');
INSERT INTO currency VALUES ('Pesos', 'COP', N'$');
INSERT INTO currency VALUES ('Colón', 'CRC', N'₡');
INSERT INTO currency VALUES ('Kuna', 'HRK', N'kn');
INSERT INTO currency VALUES ('Pesos', 'CUP', N'₱');
INSERT INTO currency VALUES ('Koruny', 'CZK', N'Kč');
INSERT INTO currency VALUES ('Kroner', 'DKK', N'kr');
INSERT INTO currency VALUES ('Pesos', 'DOP ', N'RD$');
INSERT INTO currency VALUES ('Dollars', 'XCD', N'$');
INSERT INTO currency VALUES ('Pounds', 'EGP', N'£');
INSERT INTO currency VALUES ('Colones', 'SVC', N'$');
INSERT INTO currency VALUES ('Pounds', 'FKP', N'£');
INSERT INTO currency VALUES ('Dollars', 'FJD', N'$');
INSERT INTO currency VALUES ('Cedis', 'GHC', N'¢');
INSERT INTO currency VALUES ('Pounds', 'GIP', N'£');
INSERT INTO currency VALUES ('Quetzales', 'GTQ', N'Q');
INSERT INTO currency VALUES ('Pounds', 'GGP', N'£');
INSERT INTO currency VALUES ('Dollars', 'GYD', N'$');
INSERT INTO currency VALUES ('Lempiras', 'HNL', N'L');
INSERT INTO currency VALUES ('Dollars', 'HKD', N'$');
INSERT INTO currency VALUES ('Forint', 'HUF', N'Ft');
INSERT INTO currency VALUES ('Kronur', 'ISK', N'kr');
INSERT INTO currency VALUES ('Rupees', 'INR', N'Rp');
INSERT INTO currency VALUES ('Rupiahs', 'IDR', N'Rp');
INSERT INTO currency VALUES ('Rials', 'IRR', N'﷼');
INSERT INTO currency VALUES ('Pounds', 'IMP', N'£');
INSERT INTO currency VALUES ('New Shekels', 'ILS', N'₪');
INSERT INTO currency VALUES ('Dollars', 'JMD', N'J$');
INSERT INTO currency VALUES ('Yen', 'JPY', N'¥');
INSERT INTO currency VALUES ('Pounds', 'JEP', N'£');
INSERT INTO currency VALUES ('Tenge', 'KZT', N'лв');
INSERT INTO currency VALUES ('Won', 'KPW', N'₩');
INSERT INTO currency VALUES ('Won', 'KRW', N'₩');
INSERT INTO currency VALUES ('Soms', 'KGS', N'лв');
INSERT INTO currency VALUES ('Kips', 'LAK', N'₭');
INSERT INTO currency VALUES ('Lati', 'LVL', N'Ls');
INSERT INTO currency VALUES ('Pounds', 'LBP', N'£');
INSERT INTO currency VALUES ('Dollars', 'LRD', N'$');
INSERT INTO currency VALUES ('Switzerland Francs', 'CHF', N'CHF');
INSERT INTO currency VALUES ('Litai', 'LTL', N'Lt');
INSERT INTO currency VALUES ('Denars', 'MKD', N'ден');
INSERT INTO currency VALUES ('Ringgits', 'MYR', N'RM');
INSERT INTO currency VALUES ('Rupees', 'MUR', N'₨');
INSERT INTO currency VALUES ('Pesos', 'MXN', N'$');
INSERT INTO currency VALUES ('Tugriks', 'MNT', N'₮');
INSERT INTO currency VALUES ('Meticais', 'MZN', N'MT');
INSERT INTO currency VALUES ('Dollars', 'NAD', N'$');
INSERT INTO currency VALUES ('Rupees', 'NPR', N'₨');
INSERT INTO currency VALUES ('Guilders', 'ANG', N'ƒ');
INSERT INTO currency VALUES ('Dollars', 'NZD', N'$');
INSERT INTO currency VALUES ('Cordobas', 'NIO', N'C$');
INSERT INTO currency VALUES ('Nairas', 'NGN', N'₦');
INSERT INTO currency VALUES ('Krone', 'NOK', N'kr');
INSERT INTO currency VALUES ('Rials', 'OMR', N'﷼');
INSERT INTO currency VALUES ('Rupees', 'PKR', N'₨');
INSERT INTO currency VALUES ('Balboa', 'PAB', N'B/.');
INSERT INTO currency VALUES ('Guarani', 'PYG', N'Gs');
INSERT INTO currency VALUES ('Nuevos Soles', 'PEN', N'S/.');
INSERT INTO currency VALUES ('Pesos', 'PHP', N'Php');
INSERT INTO currency VALUES ('Zlotych', 'PLN', N'zł');
INSERT INTO currency VALUES ('Rials', 'QAR', N'﷼');
INSERT INTO currency VALUES ('New Lei', 'RON', N'lei');
INSERT INTO currency VALUES ('Rubles', 'RUB', N'руб');
INSERT INTO currency VALUES ('Pounds', 'SHP', N'£');
INSERT INTO currency VALUES ('Riyals', 'SAR', N'﷼');
INSERT INTO currency VALUES ('Dinars', 'RSD', N'Дин.');
INSERT INTO currency VALUES ('Rupees', 'SCR', N'₨');
INSERT INTO currency VALUES ('Dollars', 'SGD', N'$');
INSERT INTO currency VALUES ('Dollars', 'SBD', N'$');
INSERT INTO currency VALUES ('Shillings', 'SOS', N'S');
INSERT INTO currency VALUES ('Rand', 'ZAR', N'R');
INSERT INTO currency VALUES ('Rupees', 'LKR', N'₨');
INSERT INTO currency VALUES ('Kronor', 'SEK', N'kr');
INSERT INTO currency VALUES ('Dollars', 'SRD', N'$');
INSERT INTO currency VALUES ('Pounds', 'SYP', N'£');
INSERT INTO currency VALUES ('New Dollars', 'TWD', N'NT$');
INSERT INTO currency VALUES ('Baht', 'THB', N'฿');
INSERT INTO currency VALUES ('Dollars', 'TTD', N'TT$');
INSERT INTO currency VALUES ('Lira', 'TRY', N'₺');
INSERT INTO currency VALUES ('Liras', 'TRL', N'£');
INSERT INTO currency VALUES ('Dollars', 'TVD', N'$');
INSERT INTO currency VALUES ('Hryvnia', 'UAH', N'₴');
INSERT INTO currency VALUES ('Pesos', 'UYU', N'$U');
INSERT INTO currency VALUES ('Sums', 'UZS', N'лв');
INSERT INTO currency VALUES ('Bolivares Fuertes', 'VEF', N'Bs');
INSERT INTO currency VALUES ('Dong', 'VND', N'₫');
INSERT INTO currency VALUES ('Rials', 'YER', N'﷼');
INSERT INTO currency VALUES ('Zimbabwe Dollars', 'ZWD', N'Z$');
INSERT INTO currency VALUES ('Rupees', 'INR', N'₹');

-- Select values from table
SELECT * FROM currency;

@duemme
Copy link

duemme commented Feb 14, 2021

Thank you. I'm new to databases. If I want to use this table, do I need to add an ID and then create a foreign key to this table?

@zefir-git
Copy link

zefir-git commented Mar 16, 2021

Duplicate entries, missing country alpha2, improper database config. Couldn't set indices because, again, duplicate entries.

@rafidkotta
Copy link

With latest updates and without duplication and missing currencies :-

50 Currencies added
India latest symbol without duplication
Total 162 Currencies

INSERT INTO currency (name, code, symbol) VALUES ('Leke', 'ALL', 'Lek');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'USD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Afghanis', 'AFN', '؋');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'ARS', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Guilders', 'AWG', 'ƒ');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'AUD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('New Manats', 'AZN', 'ман');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BSD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BBD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Rubles', 'BYR', 'p.');
INSERT INTO currency (name, code, symbol) VALUES ('Euro', 'EUR', '€');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BZD', 'BZ$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BMD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Bolivianos', 'BOB', '$b');
INSERT INTO currency (name, code, symbol) VALUES ('Convertible Marka', 'BAM', 'KM');
INSERT INTO currency (name, code, symbol) VALUES ('Pula', 'BWP', 'P');
INSERT INTO currency (name, code, symbol) VALUES ('Leva', 'BGN', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Reais', 'BRL', 'R$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'GBP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'BND', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Riels', 'KHR', '៛');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'CAD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'KYD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'CLP', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Yuan Renminbi', 'CNY', '¥');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'COP', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Colón', 'CRC', '₡');
INSERT INTO currency (name, code, symbol) VALUES ('Kuna', 'HRK', 'kn');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'CUP', '₱');
INSERT INTO currency (name, code, symbol) VALUES ('Koruny', 'CZK', 'Kč');
INSERT INTO currency (name, code, symbol) VALUES ('Kroner', 'DKK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'DOP ', 'RD$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'XCD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'EGP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Colones', 'SVC', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'FKP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'FJD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Cedis', 'GHC', '¢');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'GIP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Quetzales', 'GTQ', 'Q');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'GGP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'GYD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Lempiras', 'HNL', 'L');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'HKD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Forint', 'HUF', 'Ft');
INSERT INTO currency (name, code, symbol) VALUES ('Kronur', 'ISK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'INR', '₹');
INSERT INTO currency (name, code, symbol) VALUES ('Rupiahs', 'IDR', 'Rp');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'IRR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'IMP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('New Shekels', 'ILS', '₪');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'JMD', 'J$');
INSERT INTO currency (name, code, symbol) VALUES ('Yen', 'JPY', '¥');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'JEP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Tenge', 'KZT', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Won', 'KPW', '₩');
INSERT INTO currency (name, code, symbol) VALUES ('Won', 'KRW', '₩');
INSERT INTO currency (name, code, symbol) VALUES ('Soms', 'KGS', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Kips', 'LAK', '₭');
INSERT INTO currency (name, code, symbol) VALUES ('Lati', 'LVL', 'Ls');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'LBP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'LRD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Switzerland Francs', 'CHF', 'CHF');
INSERT INTO currency (name, code, symbol) VALUES ('Litai', 'LTL', 'Lt');
INSERT INTO currency (name, code, symbol) VALUES ('Denars', 'MKD', 'ден');
INSERT INTO currency (name, code, symbol) VALUES ('Ringgits', 'MYR', 'RM');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'MUR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'MXN', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Tugriks', 'MNT', '₮');
INSERT INTO currency (name, code, symbol) VALUES ('Meticais', 'MZN', 'MT');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'NAD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'NPR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Guilders', 'ANG', 'ƒ');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'NZD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Cordobas', 'NIO', 'C$');
INSERT INTO currency (name, code, symbol) VALUES ('Nairas', 'NGN', '₦');
INSERT INTO currency (name, code, symbol) VALUES ('Krone', 'NOK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'OMR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'PKR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Balboa', 'PAB', 'B/.');
INSERT INTO currency (name, code, symbol) VALUES ('Guarani', 'PYG', 'Gs');
INSERT INTO currency (name, code, symbol) VALUES ('Nuevos Soles', 'PEN', 'S/.');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'PHP', 'Php');
INSERT INTO currency (name, code, symbol) VALUES ('Zlotych', 'PLN', 'zł');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'QAR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('New Lei', 'RON', 'lei');
INSERT INTO currency (name, code, symbol) VALUES ('Rubles', 'RUB', 'руб');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'SHP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Riyals', 'SAR', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Dinars', 'RSD', 'Дин.');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'SCR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'SGD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'SBD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Shillings', 'SOS', 'S');
INSERT INTO currency (name, code, symbol) VALUES ('Rand', 'ZAR', 'R');
INSERT INTO currency (name, code, symbol) VALUES ('Rupees', 'LKR', '₨');
INSERT INTO currency (name, code, symbol) VALUES ('Kronor', 'SEK', 'kr');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'SRD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Pounds', 'SYP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('New Dollars', 'TWD', 'NT$');
INSERT INTO currency (name, code, symbol) VALUES ('Baht', 'THB', '฿');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'TTD', 'TT$');
INSERT INTO currency (name, code, symbol) VALUES ('Lira', 'TRY', '₺');
INSERT INTO currency (name, code, symbol) VALUES ('Liras', 'TRL', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Dollars', 'TVD', '$');
INSERT INTO currency (name, code, symbol) VALUES ('Hryvnia', 'UAH', '₴');
INSERT INTO currency (name, code, symbol) VALUES ('Pesos', 'UYU', '$U');
INSERT INTO currency (name, code, symbol) VALUES ('Sums', 'UZS', 'лв');
INSERT INTO currency (name, code, symbol) VALUES ('Bolivares Fuertes', 'VEF', 'Bs');
INSERT INTO currency (name, code, symbol) VALUES ('Dong', 'VND', '₫');
INSERT INTO currency (name, code, symbol) VALUES ('Rials', 'YER', '﷼');
INSERT INTO currency (name, code, symbol) VALUES ('Zimbabwe Dollars', 'ZWD', 'Z$');
INSERT INTO currency (name, code, symbol) VALUES ('Algerian dinar', 'DZD', 'DA');
INSERT INTO currency (name, code, symbol) VALUES ('Angolan kwanza', 'AOA', 'Kz');
INSERT INTO currency (name, code, symbol) VALUES ('Armenian dram', 'AMD', '֏');
INSERT INTO currency (name, code, symbol) VALUES ('Bahraini dinar', 'BHD', 'BD');
INSERT INTO currency (name, code, symbol) VALUES ('Bangladeshi taka', 'BDT', '৳');
INSERT INTO currency (name, code, symbol) VALUES ('West African CFA franc', 'XOF', 'CFA');
INSERT INTO currency (name, code, symbol) VALUES ('Burundian franc', 'BIF', 'FBu');
INSERT INTO currency (name, code, symbol) VALUES ('Central African CFA franc', 'XAF', 'FCFA');
INSERT INTO currency (name, code, symbol) VALUES ('Cape Verdean escudo', 'CVE', 'Esc');
INSERT INTO currency (name, code, symbol) VALUES ('Comorian franc', 'KMF', 'CF');
INSERT INTO currency (name, code, symbol) VALUES ('Djiboutian franc', 'DJF', 'Fdj');
INSERT INTO currency (name, code, symbol) VALUES ('Dominican peso', 'DOP', 'RD$');
INSERT INTO currency (name, code, symbol) VALUES ('Eritrean nakfa', 'ERN', 'Nkf');
INSERT INTO currency (name, code, symbol) VALUES ('Ethiopian birr', 'ETB', 'Br');
INSERT INTO currency (name, code, symbol) VALUES ('CFP franc', 'XPF', '₣');
INSERT INTO currency (name, code, symbol) VALUES ('Gambian dalasi', 'GMD', 'D');
INSERT INTO currency (name, code, symbol) VALUES ('Georgian lari', 'GEL', 'ლ');
INSERT INTO currency (name, code, symbol) VALUES ('Ghanaian cedi', 'GHS', 'GH₵');
INSERT INTO currency (name, code, symbol) VALUES ('Guinean franc', 'GNF', 'FG');
INSERT INTO currency (name, code, symbol) VALUES ('Iraqi dinar', 'IQD', 'ع.د');
INSERT INTO currency (name, code, symbol) VALUES ('Jordanian dinar', 'JOD', 'د.ا');
INSERT INTO currency (name, code, symbol) VALUES ('Kenyan shilling', 'KES', 'Ksh');
INSERT INTO currency (name, code, symbol) VALUES ('Kuwaiti dinar', 'KWD', 'د.ك');
INSERT INTO currency (name, code, symbol) VALUES ('Libyan dinar', 'LYD', 'ل.د');
INSERT INTO currency (name, code, symbol) VALUES ('Macanese pataca', 'MOP', 'MOP$');
INSERT INTO currency (name, code, symbol) VALUES ('Malagasy ariary', 'MGA', 'Ar');
INSERT INTO currency (name, code, symbol) VALUES ('Malawian kwacha', 'MWK', 'MK');
INSERT INTO currency (name, code, symbol) VALUES ('Maldivian rufiyaa', 'MVR', 'Rf');
INSERT INTO currency (name, code, symbol) VALUES ('Mauritanian ouguiya', 'MRO', 'UM');
INSERT INTO currency (name, code, symbol) VALUES ('Moldovan leu', 'MDL', 'L');
INSERT INTO currency (name, code, symbol) VALUES ('Moroccan dirham', 'MAD', 'MAD');
INSERT INTO currency (name, code, symbol) VALUES ('Myanmar kyat', 'MMK', 'K');
INSERT INTO currency (name, code, symbol) VALUES ('Papua New Guinean kina', 'PGK', 'K');
INSERT INTO currency (name, code, symbol) VALUES ('Rwandan franc', 'RWF', 'R₣');
INSERT INTO currency (name, code, symbol) VALUES ('Samoan tālā', 'WST', 'WS$');
INSERT INTO currency (name, code, symbol) VALUES ('São Tomé and Príncipe dobra', 'STD', 'Db');
INSERT INTO currency (name, code, symbol) VALUES ('Sierra Leonean leone', 'SLL', 'Le');
INSERT INTO currency (name, code, symbol) VALUES ('South Sudanese pound', 'SSP', '£');
INSERT INTO currency (name, code, symbol) VALUES ('Sudanese pound', 'SDG', 'ج.س');
INSERT INTO currency (name, code, symbol) VALUES ('Swazi lilangeni', 'SZL', 'L');
INSERT INTO currency (name, code, symbol) VALUES ('Tajikistani somoni', 'TJS', 'ЅM');
INSERT INTO currency (name, code, symbol) VALUES ('Tanzanian shilling', 'TZS', 'TSh');
INSERT INTO currency (name, code, symbol) VALUES ('Tongan paʻanga', 'TOP', 'T$');
INSERT INTO currency (name, code, symbol) VALUES ('Tunisian dinar', 'TND', 'DT');
INSERT INTO currency (name, code, symbol) VALUES ('Turkmenistani manat', 'TMT', 'T');
INSERT INTO currency (name, code, symbol) VALUES ('Ugandan shilling', 'UGX', 'USh');
INSERT INTO currency (name, code, symbol) VALUES ('United Arab Emirates dirham', 'AED', 'د.إ');
INSERT INTO currency (name, code, symbol) VALUES ('Vanuatu vatu', 'VUV', 'VT');
INSERT INTO currency (name, code, symbol) VALUES ('Zambian kwacha', 'ZMW', 'ZK');
INSERT INTO currency (name, code, symbol) VALUES ('Zimbabwean dollar', 'ZWL', '$');

@dyaskur
Copy link

dyaskur commented Jul 4, 2021

anyone have list with countries? example AUD, australian dollar, PHP philipine pesos, OMR Omani rials, etc?

@zefir-git
Copy link

zefir-git commented Jul 4, 2021

anyone have list with countries? example AUD, australian dollar, PHP philipine pesos, OMR Omani rials, etc?

I do, but it is hardly exhaustive. It features only like the top 15 currencies and all, or at least most, countries that utilise them. Let me know if that works for you

@dyaskur
Copy link

dyaskur commented Jul 4, 2021

anyone have list with countries? example AUD, australian dollar, PHP philipine pesos, OMR Omani rials, etc?

I do, but it is hardly exhaustive. It features only like the top 15 currencies and all, or at least most, countries that utilise them. Let me know if that works for you

I would be grateful if you give me that, it's better than nothing,

@zefir-git
Copy link

zefir-git commented Jul 5, 2021

MariaDB 10+ required (MySQL)

-- Table
CREATE TABLE `currencies` (
  `alpha2` varchar(2) NOT NULL,
  `iso` varchar(3) NOT NULL,
  `symbol` varchar(10) CHARACTER SET utf8 NOT NULL,
  `prefix` int(1) NOT NULL DEFAULT 1 COMMENT '1/0 symbol prefix/suffix',
  `rate` float NOT NULL COMMENT 'exchange rate',
  `updated` datetime NOT NULL DEFAULT utc_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data

INSERT INTO `currencies` (`alpha2`, `iso`, `symbol`, `prefix`, `rate`, `updated`) VALUES
('AT', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('AU', 'AUD', '$', 1, 1.57653, '2021-07-04 17:00:01'),
('BE', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('BG', 'BGN', 'лв.', 0, 1.95595, '2021-07-04 17:00:01'),
('BN', 'SGD', 'S$', 1, 1.59834, '2021-07-04 17:00:01'),
('BR', 'BRL', 'R$', 1, 6.00211, '2021-07-04 17:00:01'),
('BT', 'INR', '', 1, 88.4162, '2021-07-04 17:00:01'),
('CA', 'CAD', '$', 1, 1.46195, '2021-07-04 17:00:01'),
('CH', 'CHF', ' Fr.', 0, 1.09287, '2021-07-04 17:00:01'),
('CK', 'NZD', '$', 1, 1.68813, '2021-07-04 17:00:01'),
('CN', 'CNY', '¥', 1, 7.68026, '2021-07-04 17:00:01'),
('CX', 'AUD', '$', 1, 1.57653, '2021-07-04 17:00:01'),
('CY', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('CZ', 'CZK', '', 0, 25.5722, '2021-07-04 17:00:01'),
('DE', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('DK', 'DKK', ' kr.', 0, 7.43576, '2021-07-04 17:00:01'),
('EC', 'USD', '$', 1, 1.1865, '2021-07-04 17:00:01'),
('EE', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('ES', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('FI', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('FJ', 'NZD', '$', 1, 1.68813, '2021-07-04 17:00:01'),
('FR', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('GB', 'GBP', '£', 1, 0.858383, '2021-07-04 17:00:01'),
('GL', 'DKK', ' kr.', 0, 7.43576, '2021-07-04 17:00:01'),
('GR', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('HK', 'HKD', 'HK$', 1, 9.21392, '2021-07-04 17:00:01'),
('HR', 'HRK', ' kn', 0, 7.48923, '2021-07-04 17:00:01'),
('HU', 'HUF', ' Ft', 0, 351.7, '2021-07-04 17:00:01'),
('ID', 'IDR', 'Rp', 1, 17156.3, '2021-07-04 17:00:01'),
('IE', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('IL', 'ILS', '', 1, 3.88292, '2021-07-04 17:00:01'),
('IN', 'INR', '', 1, 88.4162, '2021-07-04 17:00:01'),
('IS', 'ISK', ' kr', 0, 147.103, '2021-07-04 17:00:01'),
('IT', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('JP', 'JPY', '¥', 1, 131.743, '2021-07-04 17:00:01'),
('KH', 'USD', '$', 1, 1.1865, '2021-07-04 17:00:01'),
('KR', 'KRW', '', 1, 1341.66, '2021-07-04 17:00:01'),
('LB', 'USD', '$', 1, 1.1865, '2021-07-04 17:00:01'),
('LT', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('LU', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('LV', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('MH', 'USD', '$', 1, 1.1865, '2021-07-04 17:00:01'),
('MT', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('MX', 'MXN', '$', 1, 23.46, '2021-07-04 17:00:01'),
('MY', 'MYR', 'RM', 1, 4.94, '2021-07-04 17:00:01'),
('NL', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('NO', 'NOK', ' kr', 0, 10.1986, '2021-07-04 17:00:01'),
('NP', 'INR', '', 1, 88.4162, '2021-07-04 17:00:01'),
('NZ', 'NZD', '$', 1, 1.68813, '2021-07-04 17:00:01'),
('PA', 'USD', '$', 1, 1.1865, '2021-07-04 17:00:01'),
('PG', 'AUD', '$', 1, 1.57653, '2021-07-04 17:00:01'),
('PH', 'PHP', '', 1, 58.269, '2021-07-04 17:00:01'),
('PL', 'PLN', '', 0, 4.51013, '2021-07-04 17:00:01'),
('PS', 'ILS', '', 1, 3.88292, '2021-07-04 17:00:01'),
('PT', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('RO', 'RON', ' lei', 0, 4.92813, '2021-07-04 17:00:01'),
('RU', 'RUB', '', 1, 86.8471, '2021-07-04 17:00:01'),
('SE', 'SEK', ' kr', 0, 10.1283, '2021-07-04 17:00:01'),
('SG', 'SGD', 'S$', 1, 1.59834, '2021-07-04 17:00:01'),
('SI', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('SK', 'EUR', '', 1, 1, '2021-07-04 17:00:01'),
('SO', 'USD', '$', 1, 1.1865, '2021-07-04 17:00:01'),
('SV', 'USD', '$', 1, 1.1865, '2021-07-04 17:00:01'),
('TH', 'THB', '฿', 1, 38.1175, '2021-07-04 17:00:01'),
('TR', 'TRY', '', 1, 10.3106, '2021-07-04 17:00:01'),
('US', 'USD', '$', 1, 1.1865, '2021-07-04 17:00:01'),
('ZW', 'INR', '', 1, 88.4162, '2021-07-04 17:00:01');

-- Indices
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`alpha2`);
COMMIT;

@amin4code
Copy link

A bulk insert SQL modified from "rafidkotta" (thanks to rafidkotta)

INSERT INTO tbl_currencies (name, code, symbol) VALUES
('Leke', 'ALL', 'Lek'),
('Dollars', 'USD', '$'),
('Afghanistan', 'AFN', '؋'),
('Pesos', 'ARS', '$'),
('Guilders', 'AWG', 'ƒ'),
('Dollars', 'AUD', '$'),
('New Manats', 'AZN', 'ман'),
('Dollars', 'BSD', '$'),
('Dollars', 'BBD', '$'),
('Rubles', 'BYR', 'p.'),
('Euro', 'EUR', '€'),
('Dollars', 'BZD', 'BZ$'),
('Dollars', 'BMD', '$'),
('Bolivianos', 'BOB', '$b'),
('Convertible Marka', 'BAM', 'KM'),
('Pula', 'BWP', 'P'),
('Leva', 'BGN', 'лв'),
('Reais', 'BRL', 'R$'),
('Pounds', 'GBP', '£'),
('Dollars', 'BND', '$'),
('Riels', 'KHR', '៛'),
('Dollars', 'CAD', '$'),
('Dollars', 'KYD', '$'),
('Pesos', 'CLP', '$'),
('Yuan Renminbi', 'CNY', '¥'),
('Pesos', 'COP', '$'),
('Colón', 'CRC', '₡'),
('Kuna', 'HRK', 'kn'),
('Pesos', 'CUP', '₱'),
('Koruny', 'CZK', 'Kč'),
('Kroner', 'DKK', 'kr'),
('Dollars', 'XCD', '$'),
('Pounds', 'EGP', '£'),
('Colones', 'SVC', '$'),
('Pounds', 'FKP', '£'),
('Dollars', 'FJD', '$'),
('Cedis', 'GHC', '¢'),
('Pounds', 'GIP', '£'),
('Quetzales', 'GTQ', 'Q'),
('Pounds', 'GGP', '£'),
('Dollars', 'GYD', '$'),
('Lempiras', 'HNL', 'L'),
('Dollars', 'HKD', '$'),
('Forint', 'HUF', 'Ft'),
('Kronur', 'ISK', 'kr'),
('Rupees', 'INR', '₹'),
('Rupiahs', 'IDR', 'Rp'),
('Rials', 'IRR', '﷼'),
('Pounds', 'IMP', '£'),
('New Shekels', 'ILS', '₪'),
('Dollars', 'JMD', 'J$'),
('Yen', 'JPY', '¥'),
('Pounds', 'JEP', '£'),
('Tenge', 'KZT', 'лв'),
('Won', 'KPW', '₩'),
('Won', 'KRW', '₩'),
('Soms', 'KGS', 'лв'),
('Kips', 'LAK', '₭'),
('Lati', 'LVL', 'Ls'),
('Pounds', 'LBP', '£'),
('Dollars', 'LRD', '$'),
('Switzerland Francs', 'CHF', 'CHF'),
('Litai', 'LTL', 'Lt'),
('Denars', 'MKD', 'ден'),
('Ringgits', 'MYR', 'RM'),
('Rupees', 'MUR', '₨'),
('Pesos', 'MXN', '$'),
('Tugriks', 'MNT', '₮'),
('Meticais', 'MZN', 'MT'),
('Dollars', 'NAD', '$'),
('Rupees', 'NPR', '₨'),
('Guilders', 'ANG', 'ƒ'),
('Dollars', 'NZD', '$'),
('Cordobas', 'NIO', 'C$'),
('Nairas', 'NGN', '₦'),
('Krone', 'NOK', 'kr'),
('Rials', 'OMR', '﷼'),
('Rupees', 'PKR', '₨'),
('Balboa', 'PAB', 'B/.'),
('Guarani', 'PYG', 'Gs'),
('Nuevos Soles', 'PEN', 'S/.'),
('Pesos', 'PHP', 'Php'),
('Zlotych', 'PLN', 'zł'),
('Rials', 'QAR', '﷼'),
('New Lei', 'RON', 'lei'),
('Rubles', 'RUB', 'руб'),
('Pounds', 'SHP', '£'),
('Riyals', 'SAR', '﷼'),
('Dinars', 'RSD', 'Дин.'),
('Rupees', 'SCR', '₨'),
('Dollars', 'SGD', '$'),
('Dollars', 'SBD', '$'),
('Shillings', 'SOS', 'S'),
('Rand', 'ZAR', 'R'),
('Rupees', 'LKR', '₨'),
('Kronor', 'SEK', 'kr'),
('Dollars', 'SRD', '$'),
('Pounds', 'SYP', '£'),
('New Dollars', 'TWD', 'NT$'),
('Baht', 'THB', '฿'),
('Dollars', 'TTD', 'TT$'),
('Lira', 'TRY', '₺'),
('Liras', 'TRL', '£'),
('Dollars', 'TVD', '$'),
('Hryvnia', 'UAH', '₴'),
('Pesos', 'UYU', '$U'),
('Sums', 'UZS', 'лв'),
('Bolivares Fuertes', 'VEF', 'Bs'),
('Dong', 'VND', '₫'),
('Rials', 'YER', '﷼'),
('Zimbabwe Dollars', 'ZWD', 'Z$'),
('Algerian dinar', 'DZD', 'DA'),
('Angolan kwanza', 'AOA', 'Kz'),
('Armenian dram', 'AMD', '֏'),
('Bahraini dinar', 'BHD', 'BD'),
('Bangladeshi taka', 'BDT', '৳'),
('West African CFA franc', 'XOF', 'CFA'),
('Burundian franc', 'BIF', 'FBu'),
('Central African CFA franc', 'XAF', 'FCFA'),
('Cape Verdean escudo', 'CVE', 'Esc'),
('Comorian franc', 'KMF', 'CF'),
('Djiboutian franc', 'DJF', 'Fdj'),
('Dominican peso', 'DOP', 'RD$'),
('Eritrean nakfa', 'ERN', 'Nkf'),
('Ethiopian birr', 'ETB', 'Br'),
('CFP franc', 'XPF', '₣'),
('Gambian dalasi', 'GMD', 'D'),
('Georgian lari', 'GEL', 'ლ'),
('Ghanaian cedi', 'GHS', 'GH₵'),
('Guinean franc', 'GNF', 'FG'),
('Iraqi dinar', 'IQD', 'ع.د'),
('Jordanian dinar', 'JOD', 'د.ا'),
('Kenyan shilling', 'KES', 'Ksh'),
('Kuwaiti dinar', 'KWD', 'د.ك'),
('Libyan dinar', 'LYD', 'ل.د'),
('Macanese pataca', 'MOP', 'MOP$'),
('Malagasy ariary', 'MGA', 'Ar'),
('Malawian kwacha', 'MWK', 'MK'),
('Maldivian rufiyaa', 'MVR', 'Rf'),
('Mauritanian ouguiya', 'MRO', 'UM'),
('Moldovan leu', 'MDL', 'L'),
('Moroccan dirham', 'MAD', 'MAD'),
('Myanmar kyat', 'MMK', 'K'),
('Papua New Guinean kina', 'PGK', 'K'),
('Rwandan franc', 'RWF', 'R₣'),
('Samoan tālā', 'WST', 'WS$'),
('São Tomé and Príncipe dobra', 'STD', 'Db'),
('Sierra Leonean leone', 'SLL', 'Le'),
('South Sudanese pound', 'SSP', '£'),
('Sudanese pound', 'SDG', 'ج.س'),
('Swazi lilangeni', 'SZL', 'L'),
('Tajikistani somoni', 'TJS', 'ЅM'),
('Tanzanian shilling', 'TZS', 'TSh'),
('Tongan paʻanga', 'TOP', 'T$'),
('Tunisian dinar', 'TND', 'DT'),
('Turkmenistani manat', 'TMT', 'T'),
('Ugandan shilling', 'UGX', 'USh'),
('United Arab Emirates dirham', 'AED', 'د.إ'),
('Vanuatu vatu', 'VUV', 'VT'),
('Zambian kwacha', 'ZMW', 'ZK'),
('Zimbabwean dollar', 'ZWL', '$');

@abdulroufsidhu
Copy link

abdulroufsidhu commented Jan 11, 2022

-- Pakistani currency
INSERT INTO currency VALUES ('Rupees', 'PKR', '/=');

@davinderantil
Copy link

Hi everyone , I have the file that Support symbol in SQL DB Too.

CREATE TABLE LKP_SOC_CurrencySymbol (
ID INT IDENTITY(1,1) PRIMARY KEY,
CurrencyName NVARCHAR(50),
CurrencyCode NVARCHAR(3),
CurrencySymbol NVARCHAR(5)
)

INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Leke',N'ALL',N'Lek');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'USD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Afghanis',N'AFN',N'؋');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pesos',N'ARS',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Guilders',N'AWG',N'ƒ');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'AUD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('New Manats',N'AZN',N'ман');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'BSD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'BBD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rubles',N'BYR',N'p.');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Euro',N'EUR',N'€');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'BZD',N'BZ$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'BMD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Bolivianos',N'BOB',N'$b');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Convertible Marka',N'BAM',N'KM');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pula',N'BWP',N'P');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Leva',N'BGN',N'лв');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Reais',N'BRL',N'R$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'GBP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'BND',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Riels',N'KHR',N'៛');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'CAD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'KYD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pesos',N'CLP',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Yuan Renminbi',N'CNY',N'¥');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pesos',N'COP',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Colón',N'CRC',N'₡');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Kuna',N'HRK',N'kn');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pesos',N'CUP',N'₱');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Koruny',N'CZK',N'Kč');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Kroner',N'DKK',N'kr');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pesos',N'DOP ',N'RD$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'XCD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'EGP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Colones',N'SVC',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'FKP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'FJD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Cedis',N'GHC',N'¢');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'GIP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Quetzales',N'GTQ',N'Q');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'GGP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'GYD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Lempiras',N'HNL',N'L');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'HKD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Forint',N'HUF',N'Ft');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Kronur',N'ISK',N'kr');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rupees',N'INR', N'₹');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rupiahs',N'IDR',N'Rp');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rials',N'IRR',N'﷼');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'IMP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('New Shekels',N'ILS',N'₪');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'JMD',N'J$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Yen',N'JPY',N'¥');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'JEP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Tenge',N'KZT',N'лв');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Won',N'KPW',N'₩');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Won',N'KRW',N'₩');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Soms',N'KGS',N'лв');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Kips',N'LAK',N'₭');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Lati',N'LVL',N'Ls');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'LBP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'LRD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Switzerland Francs',N'CHF',N'CHF');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Litai',N'LTL',N'Lt');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Denars',N'MKD',N'ден');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Ringgits',N'MYR',N'RM');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rupees',N'MUR',N'₨');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pesos',N'MXN',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Tugriks',N'MNT',N'₮');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Meticais',N'MZN',N'MT');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'NAD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rupees',N'NPR',N'₨');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Guilders',N'ANG',N'ƒ');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'NZD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Cordobas',N'NIO',N'C$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Nairas',N'NGN',N'₦');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Krone',N'NOK',N'kr');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rials',N'OMR',N'﷼');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rupees',N'PKR',N'₨');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Balboa',N'PAB',N'B/.');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Guarani',N'PYG',N'Gs');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Nuevos Soles',N'PEN',N'S/.');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pesos',N'PHP',N'Php');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Zlotych',N'PLN',N'zł');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rials',N'QAR',N'﷼');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('New Lei',N'RON',N'lei');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rubles',N'RUB',N'руб');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'SHP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Riyals',N'SAR',N'﷼');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dinars',N'RSD',N'Дин.');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rupees',N'SCR',N'₨');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'SGD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'SBD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Shillings',N'SOS',N'S');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rand',N'ZAR',N'R');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rupees',N'LKR',N'₨');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Kronor',N'SEK',N'kr');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'SRD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pounds',N'SYP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('New Dollars',N'TWD',N'NT$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Baht',N'THB',N'฿');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'TTD',N'TT$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Lira',N'TRY',N'₺');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Liras',N'TRL',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dollars',N'TVD',N'$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Hryvnia',N'UAH',N'₴');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Pesos',N'UYU',N'$U');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Sums',N'UZS',N'лв');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Bolivares Fuertes',N'VEF',N'Bs');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dong',N'VND',N'₫');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rials',N'YER',N'﷼');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Zimbabwe Dollars',N'ZWD',N'Z$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Algerian dinar',N'DZD',N'DA');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Angolan kwanza',N'AOA',N'Kz');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Armenian dram',N'AMD',N'֏');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Bahraini dinar',N'BHD',N'BD');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Bangladeshi taka',N'BDT',N'৳');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('West African CFA franc',N'XOF',N'CFA');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Burundian franc',N'BIF',N'FBu');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Central African CFA franc',N'XAF',N'FCFA');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Cape Verdean escudo',N'CVE',N'Esc');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Comorian franc',N'KMF',N'CF');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Djiboutian franc',N'DJF',N'Fdj');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Dominican peso',N'DOP',N'RD$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Eritrean nakfa',N'ERN',N'Nkf');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Ethiopian birr',N'ETB',N'Br');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('CFP franc',N'XPF',N'₣');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Gambian dalasi',N'GMD',N'D');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Georgian lari',N'GEL',N'ლ');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Ghanaian cedi',N'GHS',N'GH₵');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Guinean franc',N'GNF',N'FG');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Iraqi dinar',N'IQD',N'ع.د');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Jordanian dinar',N'JOD',N'د.ا');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Kenyan shilling',N'KES',N'Ksh');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Kuwaiti dinar',N'KWD',N'د.ك');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Libyan dinar',N'LYD',N'ل.د');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Macanese pataca',N'MOP',N'MOP$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Malagasy ariary',N'MGA',N'Ar');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Malawian kwacha',N'MWK',N'MK');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Maldivian rufiyaa',N'MVR',N'Rf');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Mauritanian ouguiya',N'MRO',N'UM');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Moldovan leu',N'MDL',N'L');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Moroccan dirham',N'MAD',N'MAD');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Myanmar kyat',N'MMK',N'K');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Papua New Guinean kina',N'PGK',N'K');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Rwandan franc',N'RWF',N'R₣');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Samoan tālā',N'WST',N'WS$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('São Tomé and Príncipe dobra',N'STD',N'Db');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Sierra Leonean leone',N'SLL',N'Le');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('South Sudanese pound',N'SSP',N'£');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Sudanese pound',N'SDG',N'ج.س');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Swazi lilangeni',N'SZL',N'L');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Tajikistani somoni',N'TJS',N'ЅM');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Tanzanian shilling',N'TZS',N'TSh');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Tongan paʻanga',N'TOP',N'T$');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Tunisian dinar',N'TND',N'DT');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Turkmenistani manat',N'TMT',N'T');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Ugandan shilling',N'UGX',N'USh');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('United Arab Emirates dirham',N'AED',N'د.إ');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Vanuatu vatu',N'VUV',N'VT');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Zambian kwacha',N'ZMW',N'ZK');
INSERT INTO LKP_SOC_CurrencySymbol (CurrencyName, CurrencyCode, CurrencySymbol) VALUES ('Zimbabwean dollar',N'ZWL',N'$');

@mmunchandersen
Copy link

I needed a table where the CurrencyCode was the primary key and combined the above scripts to this:

CREATE TABLE [dbo].[Currency](
[CurrencyCode] nvarchar NOT NULL,
[CurrencyName] nvarchar NOT NULL,
[CurrencySymbol] nvarchar NULL,
[Country] nvarchar NOT NULL,
[Comments] varchar NULL,
CONSTRAINT [PK_Currency_1] PRIMARY KEY CLUSTERED
(
[CurrencyCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AED', N'UAE dirham', N'د.إ', N'United Arab Emirates', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AFN', N'Afghan afghani', N'؋', N'Afghanistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ALL', N'Albanian lek', N'Lek', N'Albania', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AMD', N'Armenian dram', N'֏', N'Armenia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ANG', N'Netherlands Antillean guilder', N'ƒ', N'Curacao (Netherlands), Sint Maarten (Netherlands)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AOA', N'Angolan kwanza', N'Kz', N'Angola', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ARS', N'Argentine peso', N'$', N'Argentina', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AUD', N'Australian dollar', N'$', N'Australia, Christmas Island (Australia), Cocos (Keeling) Islands (Australia), Kiribati, Nauru, Norfolk Island (Australia), Tuvalu', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AWG', N'Aruban florin', N'ƒ', N'Aruba (Netherlands)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'AZN', N'Azerbaijan manat', N'ман', N'Azerbaijan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BAM', N'Bosnia and Herzegovina convertible mark', N'KM', N'Bosnia and Herzegovina', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BBD', N'Barbadian dollar', N'$', N'Barbados', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BDT', N'Bangladeshi taka', N'৳', N'Bangladesh', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BGN', N'Bulgarian lev', N'лв', N'Bulgaria', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BHD', N'Bahraini dinar', N'BD', N'Bahrain', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BIF', N'Burundi franc', N'FBu', N'Burundi', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BMD', N'Bermudian dollar', N'$', N'Bermuda (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BND', N'Brunei dollar', N'$', N'Brunei', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BOB', N'Bolivian boliviano', N'$b', N'Bolivia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BRL', N'Brazilian real', N'R$', N'Brazil', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BSD', N'Bahamian dollar', N'$', N'Bahamas', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BTN', N'Bhutanese ngultrum', NULL, N'Bhutan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BWP', N'Botswana pula', N'P', N'Botswana', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BYN', N'Belarusian ruble', NULL, N'Belarus', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'BZD', N'Belize dollar', N'BZ$', N'Belize', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CAD', N'Canadian dollar', N'$', N'Canada', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CDF', N'Congolese franc', NULL, N'Congo, Democratic Republic of the', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CHF', N'Swiss franc', N'CHF', N'Liechtenstein, Switzerland', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CKD', N'Cook Islands dollar', NULL, N'Cook Islands (New Zealand)', N'This currency code is not part of the ISO 4217 standard, but is used commercially.')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CLP', N'Chilean peso', N'$', N'Chile', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CNY', N'Chinese Yuan Renminbi', N'¥', N'China', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'COP', N'Colombian peso', N'$', N'Colombia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CRC', N'Costa Rican colon', N'₡', N'Costa Rica', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CUP', N'Cuban peso', N'₱', N'Cuba', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CVE', N'Cape Verdean escudo', N'Esc', N'Cabo Verde', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'CZK', N'Czech koruna', N'Kč', N'Czechia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'DJF', N'Djiboutian franc', N'Fdj', N'Djibouti', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'DKK', N'Danish krone', N'kr', N'Denmark, Greenland (Denmark)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'DOP', N'Dominican peso', N'RD$', N'Dominican Republic', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'DZD', N'Algerian dinar', N'DA', N'Algeria', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'EGP', N'Egyptian pound', N'£', N'Egypt', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ERN', N'Eritrean nakfa', N'Nkf', N'Eritrea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ETB', N'Ethiopian birr', N'Br', N'Ethiopia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'EUR', N'European euro', N'€', N'Akrotiri and Dhekelia (UK), Aland Islands (Finland), Andorra, Austria, Belgium, Cyprus, Estonia, Finland, France, French Guiana (France), Germany, Greece, Guadeloupe (France), Ireland, Italy, Kosovo, Latvia, Lithuania, Luxembourg, Malta, Martinique (France), Mayotte (France), Monaco, Montenegro, Netherlands, Portugal, Reunion (France), Saint Barthelemy (France), Saint Martin (France), Saint Pierre and Miquelon (France), San Marino, Slovakia, Slovenia, Spain, Vatican City (Holy See)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'FJD', N'Fijian dollar', N'$', N'Fiji', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'FKP', N'Falkland Islands pound', N'£', N'Falkland Islands (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'FOK', N'Faroese krona', NULL, N'Faroe Islands (Denmark)', N'This currency code is not part of the ISO 4217 standard, but is used commercially.')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GBP', N'Pound sterling', N'£', N'South Georgia Island (UK), Tristan da Cunha (UK), United Kingdom', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GEL', N'Georgian lari', N'ლ', N'Georgia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GGP', N'Guernsey Pound', N'£', N'Guernsey (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GHS', N'Ghanaian cedi', N'GH₵', N'Ghana', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GIP', N'Gibraltar pound', N'£', N'Gibraltar (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GMD', N'Gambian dalasi', N'D', N'Gambia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GNF', N'Guinean franc', N'FG', N'Guinea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GTQ', N'Guatemalan quetzal', N'Q', N'Guatemala', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'GYD', N'Guyanese dollar', N'$', N'Guyana', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HKD', N'Hong Kong dollar', N'$', N'Hong Kong (China)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HNL', N'Honduran lempira', N'L', N'Honduras', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HRK', N'Croatian kuna', N'kn', N'Croatia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HTG', N'Haitian gourde', NULL, N'Haiti', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'HUF', N'Hungarian forint', N'Ft', N'Hungary', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'IDR', N'Indonesian rupiah', N'Rp', N'Indonesia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ILS', N'Israeli new shekel', N'₪', N'Israel, Palestine', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'IMP', N'Manx pound', N'£', N'Isle of Man (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'INR', N'Indian rupee', N'₹', N'India', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'IQD', N'Iraqi dinar', N'ع.د', N'Iraq', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'IRR', N'Iranian rial', N'﷼', N'Iran', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ISK', N'Icelandic krona', N'kr', N'Iceland', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'JEP', N'Jersey pound', N'£', N'Jersey (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'JMD', N'Jamaican dollar', N'J$', N'Jamaica', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'JOD', N'Jordanian dinar', N'د.ا', N'Jordan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'JPY', N'Japanese yen', N'¥', N'Japan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KES', N'Kenyan shilling', N'Ksh', N'Kenya', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KGS', N'Kyrgyzstani som', N'лв', N'Kyrgyzstan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KHR', N'Cambodian riel', N'៛', N'Cambodia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KMF', N'Comorian franc', N'CF', N'Comoros', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KPW', N'North Korean won', N'₩', N'North Korea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KRW', N'South Korean won', N'₩', N'South Korea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KWD', N'Kuwaiti dinar', N'د.ك', N'Kuwait', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KYD', N'Cayman Islands dollar', N'$', N'Cayman Islands (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'KZT', N'Kazakhstani tenge', N'лв', N'Kazakhstan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LAK', N'Lao kip', N'₭', N'Laos', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LBP', N'Lebanese pound', N'£', N'Lebanon', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LKR', N'Sri Lankan rupee', N'₨', N'Sri Lanka', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LRD', N'Liberian dollar', N'$', N'Liberia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LSL', N'Lesotho loti', NULL, N'Lesotho', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'LYD', N'Libyan dinar', N'ل.د', N'Libya', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MAD', N'Moroccan dirham', N'MAD', N'Morocco', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MDL', N'Moldovan leu', N'L', N'Moldova', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MGA', N'Malagasy ariary', N'Ar', N'Madagascar', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MKD', N'Macedonian denar', N'ден', N'North Macedonia (formerly Macedonia)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MMK', N'Myanmar kyat', N'K', N'Myanmar (formerly Burma)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MNT', N'Mongolian tugrik', N'₮', N'Mongolia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MOP', N'Macanese pataca', N'MOP$', N'Macau (China)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MRU', N'Mauritanian ouguiya', NULL, N'Mauritania', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MUR', N'Mauritian rupee', N'₨', N'Mauritius', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MVR', N'Maldivian rufiyaa', N'Rf', N'Maldives', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MWK', N'Malawian kwacha', N'MK', N'Malawi', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MXN', N'Mexican peso', N'$', N'Mexico', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MYR', N'Malaysian ringgit', N'RM', N'Malaysia', N'')
GO
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'MZN', N'Mozambican metical', N'MT', N'Mozambique', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NAD', N'Namibian dollar', N'$', N'Namibia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NGN', N'Nigerian naira', N'₦', N'Nigeria', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NIO', N'Nicaraguan cordoba', N'C$', N'Nicaragua', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NOK', N'Norwegian krone', N'kr', N'Norway, Svalbard and Jan Mayen (Norway)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NPR', N'Nepalese rupee', N'₨', N'Nepal', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'NZD', N'New Zealand dollar', N'$', N'Chatham Islands (New Zealand), New Zealand, Niue (New Zealand), Pitcairn Islands (UK), Tokelau (New Zealand)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'OMR', N'Omani rial', N'﷼', N'Oman', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PEN', N'Peruvian sol', N'S/.', N'Peru', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PGK', N'Papua New Guinean kina', N'K', N'Papua New Guinea', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PHP', N'Philippine peso', N'Php', N'Philippines', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PKR', N'Pakistani rupee', N'₨', N'Pakistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PLN', N'Polish zloty', N'zł', N'Poland', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'PYG', N'Paraguayan guarani', N'Gs', N'Paraguay', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'QAR', N'Qatari riyal', N'﷼', N'Qatar', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'RON', N'Romanian leu', N'lei', N'Romania', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'RSD', N'Serbian dinar', N'Дин.', N'Serbia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'RUB', N'Russian ruble', N'руб', N'Russia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'RWF', N'Rwandan franc', N'R₣', N'Rwanda', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SAR', N'Saudi Arabian riyal', N'﷼', N'Saudi Arabia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SBD', N'Solomon Islands dollar', N'$', N'Solomon Islands', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SCR', N'Seychellois rupee', N'₨', N'Seychelles', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SDG', N'Sudanese pound', N'ج.س', N'Sudan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SEK', N'Swedish krona', N'kr', N'Sweden', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SGD', N'Singapore dollar', N'$', N'Singapore', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SHP', N'Saint Helena pound', N'£', N'Ascension Island (UK), Saint Helena (UK)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SLL', N'Sierra Leonean leone', N'Le', N'Sierra Leone', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SOS', N'Somali shilling', N'S', N'Somalia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SRD', N'Surinamese dollar', N'$', N'Suriname', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SSP', N'South Sudanese pound', N'£', N'South Sudan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'STN', N'Sao Tome and Principe dobra', NULL, N'Sao Tome and Principe', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SYP', N'Syrian pound', N'£', N'Syria', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'SZL', N'Swazi lilangeni', N'L', N'Eswatini (formerly Swaziland)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'THB', N'Thai baht', N'฿', N'Thailand', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TJS', N'Tajikistani somoni', N'ЅM', N'Tajikistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TMT', N'Turkmen manat', N'T', N'Turkmenistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TND', N'Tunisian dinar', N'DT', N'Tunisia', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TOP', N'Tongan pa’anga', N'T$', N'Tonga', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TRY', N'Turkish lira', N'₺', N'Turkey', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TTD', N'Trinidad and Tobago dollar', N'TT$', N'Trinidad and Tobago', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TWD', N'New Taiwan dollar', N'NT$', N'Taiwan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'TZS', N'Tanzanian shilling', N'TSh', N'Tanzania', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'UAH', N'Ukrainian hryvnia', N'₴', N'Ukraine', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'UGX', N'Ugandan shilling', N'USh', N'Uganda', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'USD', N'United States dollar', N'$', N'American Samoa (USA), Bonaire (Netherlands), British Indian Ocean Territory (UK), British Virgin Islands (UK), Caribbean Netherlands (Netherlands), Ecuador, El Salvador, Guam (USA), Marshall Islands, Micronesia, Northern Mariana Islands (USA), Palau, Panama, Puerto Rico (USA), Saba (Netherlands), Sint Eustatius (Netherlands), Timor-Leste, Turks and Caicos Islands (UK), United States of America, US Virgin Islands (USA), Wake Island (USA), Zimbabwe', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'UYU', N'Uruguayan peso', N'$U', N'Uruguay', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'UZS', N'Uzbekistani som', N'лв', N'Uzbekistan', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'VES', N'Venezuelan bolivar', NULL, N'Venezuela', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'VND', N'Vietnamese dong', N'₫', N'Vietnam', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'VUV', N'Vanuatu vatu', N'VT', N'Vanuatu', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'WST', N'Samoan tala', N'WS$', N'Samoa', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XAF', N'Central African CFA franc', N'FCFA', N'Cameroon, Central African Republic, Chad, Congo, Republic of the, Equatorial Guinea, Gabon', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XCD', N'East Caribbean dollar', N'$', N'Anguilla (UK), Antigua and Barbuda, Dominica, Grenada, Montserrat (UK), Saint Kitts and Nevis, Saint Lucia, Saint Vincent and the Grenadines', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XDR', N'SDR (Special Drawing Right)', NULL, N'International Monetary Fund (IMF)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XOF', N'West African CFA franc', N'CFA', N'Benin, Burkina Faso, Cote d''Ivoire, Guinea-Bissau, Mali, Niger, Senegal, Togo', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'XPF', N'CFP franc', N'₣', N'French Polynesia (France), New Caledonia (France), Wallis and Futuna (France)', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'YER', N'Yemeni rial', N'﷼', N'Yemen', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ZAR', N'South African rand', N'R', N'South Africa', N'')
INSERT [dbo].[Currency] ([CurrencyCode], [CurrencyName], [CurrencySymbol], [Country], [Comments]) VALUES (N'ZMW', N'Zambian kwacha', N'ZK', N'Zambia', N'')
GO

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment