-
-
Save voskobovich/537b2000108e4781f70b to your computer and use it in GitHub Desktop.
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; |
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
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,
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', ' Kč', 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', 'zł', 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;
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', '$');
-- Pakistani currency
INSERT INTO currency VALUES ('Rupees', 'PKR', '/=');
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'$');
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
anyone have list with countries? example AUD, australian dollar, PHP philipine pesos, OMR Omani rials, etc?