Last active
July 26, 2025 17:31
-
-
Save k4kabirmalik/849a2cb272614b3185e81abf8294a600 to your computer and use it in GitHub Desktop.
List of all currency with country, currency name, ISO codes, symbols, symbol position, layout direction in SQL format
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE CurrencyMeta ( | |
Country TEXT NOT NULL, | |
CurrencyName TEXT NOT NULL, | |
ISOCodeAlpha2 CHAR(2) NOT NULL, | |
ISOCodeAlpha3 CHAR(3) NOT NULL, | |
Symbol TEXT, | |
SymbolPosition TEXT CHECK (SymbolPosition IN ('prefix', 'postfix')) DEFAULT 'prefix', | |
LayoutDirection TEXT CHECK (LayoutDirection IN ('LTR', 'RTL')) DEFAULT 'LTR', | |
-- Unique constraint to avoid duplicates by country and currency code | |
UNIQUE (Country, ISOCodeAlpha3) | |
); | |
-- List of currencies with their metadata | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Afghanistan', 'Afghani', 'AF', 'AFN', '؋', 'prefix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Albania', 'Lek', 'AL', 'ALL', 'Lek', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Algeria', 'Dinar', 'DZ', 'DZD', 'دج', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Andorra', 'Euro', 'AD', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Angola', 'Kwanza', 'AO', 'AOA', 'Kz', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Antigua and Barbuda', 'Dollar', 'AG', 'XCD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Argentina', 'Peso', 'AR', 'ARS', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Armenia', 'Dram', 'AM', 'AMD', '֏', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Australia', 'Dollar', 'AU', 'AUD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Austria', 'Euro', 'AT', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Azerbaijan', 'Manat', 'AZ', 'AZN', '₼', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Bahamas', 'Dollar', 'BS', 'BSD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Bahrain', 'Dinar', 'BH', 'BHD', '.د.ب', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Bangladesh', 'Taka', 'BD', 'BDT', '৳', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Barbados', 'Dollar', 'BB', 'BBD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Belarus', 'Ruble', 'BY', 'BYN', 'Br', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Belgium', 'Euro', 'BE', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Belize', 'Dollar', 'BZ', 'BZD', 'BZ$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Benin', 'Franc', 'BJ', 'XOF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Bhutan', 'Ngultrum', 'BT', 'BTN', 'Nu.', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Bolivia', 'Boliviano', 'BO', 'BOB', 'Bs.', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Bosnia and Herzegovina', 'Marka', 'BA', 'BAM', 'KM', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Botswana', 'Pula', 'BW', 'BWP', 'P', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Brazil', 'Real', 'BR', 'BRL', 'R$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Brunei', 'Dollar', 'BN', 'BND', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Bulgaria', 'Lev', 'BG', 'BGN', 'лв', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Burkina Faso', 'Franc', 'BF', 'XOF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Burundi', 'Franc', 'BI', 'BIF', 'FBu', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Cabo Verde', 'Escudo', 'CV', 'CVE', '$', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Cambodia', 'Riel', 'KH', 'KHR', '៛', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Cameroon', 'Franc', 'CM', 'XAF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Canada', 'Dollar', 'CA', 'CAD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Central African Republic', 'Franc', 'CF', 'XAF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Chad', 'Franc', 'TD', 'XAF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Chile', 'Peso', 'CL', 'CLP', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('China', 'Yuan', 'CN', 'CNY', '¥', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Colombia', 'Peso', 'CO', 'COP', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Comoros', 'Franc', 'KM', 'KMF', 'CF', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Congo (Brazzaville)', 'Franc', 'CG', 'XAF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Congo (Kinshasa)', 'Franc', 'CD', 'CDF', 'FC', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Costa Rica', 'Colón', 'CR', 'CRC', '₡', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Croatia', 'Euro', 'HR', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Cuba', 'Peso', 'CU', 'CUP', '₱', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Cyprus', 'Euro', 'CY', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Czech Republic', 'Koruna', 'CZ', 'CZK', 'Kč', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Denmark', 'Krone', 'DK', 'DKK', 'kr', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Djibouti', 'Franc', 'DJ', 'DJF', 'Fdj', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Dominica', 'Dollar', 'DM', 'XCD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Dominican Republic', 'Peso', 'DO', 'DOP', 'RD$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Ecuador', 'United States Dollar', 'EC', 'USD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Egypt', 'Pound', 'EG', 'EGP', '£', 'prefix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('El Salvador', 'United States Dollar', 'SV', 'USD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Equatorial Guinea', 'Franc', 'GQ', 'XAF', 'FCFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Eritrea', 'Nakfa', 'ER', 'ERN', 'Nfk', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Estonia', 'Euro', 'EE', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Eswatini', 'Lilangeni', 'SZ', 'SZL', 'E', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Ethiopia', 'Birr', 'ET', 'ETB', 'Br', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Fiji', 'Dollar', 'FJ', 'FJD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Finland', 'Euro', 'FI', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('France', 'Euro', 'FR', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Gabon', 'Franc', 'GA', 'XAF', 'FCFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Gambia', 'Dalasi', 'GM', 'GMD', 'D', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Georgia', 'Lari', 'GE', 'GEL', '₾', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Germany', 'Euro', 'DE', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Ghana', 'Cedi', 'GH', 'GHS', '₵', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Greece', 'Euro', 'GR', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Grenada', 'Dollar', 'GD', 'XCD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Guatemala', 'Quetzal', 'GT', 'GTQ', 'Q', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Guinea', 'Franc', 'GN', 'GNF', 'FG', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Guinea-Bissau', 'Franc', 'GW', 'XOF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Guyana', 'Dollar', 'GY', 'GYD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Haiti', 'Gourde', 'HT', 'HTG', 'G', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Honduras', 'Lempira', 'HN', 'HNL', 'L', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Hungary', 'Forint', 'HU', 'HUF', 'Ft', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Iceland', 'Króna', 'IS', 'ISK', 'kr', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('India', 'Rupee', 'IN', 'INR', '₹', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Indonesia', 'Rupiah', 'ID', 'IDR', 'Rp', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Iran', 'Rial', 'IR', 'IRR', '﷼', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Iraq', 'Dinar', 'IQ', 'IQD', 'ع.د', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Ireland', 'Euro', 'IE', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Israel', 'Shekel', 'IL', 'ILS', '₪', 'prefix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Italy', 'Euro', 'IT', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Jamaica', 'Dollar', 'JM', 'JMD', 'J$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Japan', 'Yen', 'JP', 'JPY', '¥', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Jordan', 'Dinar', 'JO', 'JOD', 'د.ا', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Kazakhstan', 'Tenge', 'KZ', 'KZT', '₸', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Kenya', 'Shilling', 'KE', 'KES', 'KSh', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Kiribati', 'Dollar', 'KI', 'AUD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Kuwait', 'Dinar', 'KW', 'KWD', 'د.ك', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Kyrgyzstan', 'Som', 'KG', 'KGS', 'лв', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Laos', 'Kip', 'LA', 'LAK', '₭', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Latvia', 'Euro', 'LV', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Lebanon', 'Pound', 'LB', 'LBP', 'ل.ل', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Lesotho', 'Loti', 'LS', 'LSL', 'M', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Liberia', 'Dollar', 'LR', 'LRD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Libya', 'Dinar', 'LY', 'LYD', 'ل.د', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Liechtenstein', 'Franc', 'LI', 'CHF', 'Fr', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Lithuania', 'Euro', 'LT', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Luxembourg', 'Euro', 'LU', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Madagascar', 'Ariary', 'MG', 'MGA', 'Ar', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Malawi', 'Kwacha', 'MW', 'MWK', 'MK', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Malaysia', 'Ringgit', 'MY', 'MYR', 'RM', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Maldives', 'Rufiyaa', 'MV', 'MVR', 'Rf', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Mali', 'Franc', 'ML', 'XOF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Malta', 'Euro', 'MT', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Marshall Islands', 'Dollar', 'MH', 'USD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Mauritania', 'Ouguiya', 'MR', 'MRU', 'UM', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Mauritius', 'Rupee', 'MU', 'MUR', '₨', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Mexico', 'Peso', 'MX', 'MXN', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Micronesia', 'Dollar', 'FM', 'USD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Moldova', 'Leu', 'MD', 'MDL', 'L', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Monaco', 'Euro', 'MC', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Mongolia', 'Tugrik', 'MN', 'MNT', '₮', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Montenegro', 'Euro', 'ME', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Morocco', 'Dirham', 'MA', 'MAD', 'د.م.', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Mozambique', 'Metical', 'MZ', 'MZN', 'MT', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Myanmar (Burma)', 'Kyat', 'MM', 'MMK', 'K', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Namibia', 'Dollar', 'NA', 'NAD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Nauru', 'Dollar', 'NR', 'AUD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Nepal', 'Rupee', 'NP', 'NPR', '₨', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Netherlands', 'Euro', 'NL', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('New Zealand', 'Dollar', 'NZ', 'NZD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Nicaragua', 'Córdoba', 'NI', 'NIO', 'C$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Niger', 'Franc', 'NE', 'XOF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Nigeria', 'Naira', 'NG', 'NGN', '₦', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('North Macedonia', 'Denar', 'MK', 'MKD', 'ден', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Norway', 'Krone', 'NO', 'NOK', 'kr', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Oman', 'Rial', 'OM', 'OMR', '﷼', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Pakistan', 'Rupee', 'PK', 'PKR', '₨', 'prefix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Palau', 'Dollar', 'PW', 'USD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Palestine', 'Shekel', 'PS', 'ILS', '₪', 'prefix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Panama', 'Balboa', 'PA', 'PAB', 'B/.', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Papua New Guinea', 'Kina', 'PG', 'PGK', 'K', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Paraguay', 'Guarani', 'PY', 'PYG', 'Gs', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Peru', 'Sol', 'PE', 'PEN', 'S/.', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Philippines', 'Peso', 'PH', 'PHP', '₱', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Poland', 'Zloty', 'PL', 'PLN', 'zł', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Portugal', 'Euro', 'PT', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Qatar', 'Riyal', 'QA', 'QAR', '﷼', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Romania', 'Leu', 'RO', 'RON', 'lei', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Russia', 'Ruble', 'RU', 'RUB', '₽', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Rwanda', 'Franc', 'RW', 'RWF', 'RF', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Saint Kitts and Nevis', 'Dollar', 'KN', 'XCD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Saint Lucia', 'Dollar', 'LC', 'XCD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Saint Vincent and the Grenadines', 'Dollar', 'VC', 'XCD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Samoa', 'Tala', 'WS', 'WST', 'T', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('San Marino', 'Euro', 'SM', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Sao Tome and Principe', 'Dobra', 'ST', 'STN', 'Db', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Saudi Arabia', 'Riyal', 'SA', 'SAR', '﷼', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Senegal', 'Franc', 'SN', 'XOF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Serbia', 'Dinar', 'RS', 'RSD', 'дин', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Seychelles', 'Rupee', 'SC', 'SCR', '₨', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Sierra Leone', 'Leone', 'SL', 'SLE', 'Le', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Singapore', 'Dollar', 'SG', 'SGD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Slovakia', 'Euro', 'SK', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Slovenia', 'Euro', 'SI', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Solomon Islands', 'Dollar', 'SB', 'SBD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Somalia', 'Shilling', 'SO', 'SOS', 'S', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('South Africa', 'Rand', 'ZA', 'ZAR', 'R', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('South Korea', 'Won', 'KR', 'KRW', '₩', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('South Sudan', 'Pound', 'SS', 'SSP', '£', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Spain', 'Euro', 'ES', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Sri Lanka', 'Rupee', 'LK', 'LKR', '₨', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Sudan', 'Pound', 'SD', 'SDG', 'ج.س', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Suriname', 'Dollar', 'SR', 'SRD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Sweden', 'Krona', 'SE', 'SEK', 'kr', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Switzerland', 'Franc', 'CH', 'CHF', 'Fr', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Syria', 'Pound', 'SY', 'SYP', '£', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Taiwan', 'New Dollar', 'TW', 'TWD', 'NT$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Tajikistan', 'Somoni', 'TJ', 'TJS', 'ЅМ', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Tanzania', 'Shilling', 'TZ', 'TZS', 'TSh', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Thailand', 'Baht', 'TH', 'THB', '฿', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Timor-Leste', 'United States Dollar', 'TL', 'USD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Togo', 'Franc', 'TG', 'XOF', 'CFA', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Tonga', 'Paʻanga', 'TO', 'TOP', 'T$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Trinidad and Tobago', 'Dollar', 'TT', 'TTD', 'TT$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Tunisia', 'Dinar', 'TN', 'TND', 'د.ت', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Turkey', 'Lira', 'TR', 'TRY', '₺', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Turkmenistan', 'Manat', 'TM', 'TMT', 'm', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Tuvalu', 'Dollar', 'TV', 'AUD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Uganda', 'Shilling', 'UG', 'UGX', 'USh', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Ukraine', 'Hryvnia', 'UA', 'UAH', '₴', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('United Arab Emirates', 'Dirham', 'AE', 'AED', 'د.إ', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('United Kingdom', 'Pound Sterling', 'GB', 'GBP', '£', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('United States', 'Dollar', 'US', 'USD', '$', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Uruguay', 'Peso', 'UY', 'UYU', '$U', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Uzbekistan', 'Som', 'UZ', 'UZS', 'лв', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Vanuatu', 'Vatu', 'VU', 'VUV', 'Vt', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Vatican City', 'Euro', 'VA', 'EUR', '€', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Venezuela', 'Bolívar', 'VE', 'VES', 'Bs.', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Vietnam', 'Dong', 'VN', 'VND', '₫', 'postfix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Yemen', 'Rial', 'YE', 'YER', '﷼', 'postfix', 'RTL'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Zambia', 'Kwacha', 'ZM', 'ZMW', 'ZK', 'prefix', 'LTR'); | |
INSERT INTO CurrencyMeta ( Country, CurrencyName, ISOCodeAlpha2, ISOCodeAlpha3, Symbol, SymbolPosition, LayoutDirection ) | |
VALUES ('Zimbabwe', 'Dollar', 'ZW', 'ZWL', 'Z$', 'prefix', 'LTR'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment