k4kabirmalik
/ currencies.json
Last active
September 11, 2025 10:48
List of all currency with country, currency name, ISO codes, symbols, symbol position, layout direction, decimal places in JSON 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
| { | |
| "currencies": [ | |
| { | |
| "country": "Afghanistan", | |
| "currencyName": "Afghani", | |
| "isoCodeAlpha2": "AF", | |
| "isoCodeAlpha3": "AFN", | |
| "symbol": "؋", | |
| "symbolPosition": "prefix", | |
| "layoutDirection": "RTL", |
k4kabirmalik
/ CurrencyMeta.sql
Last active
September 11, 2025 13:06
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', | |
| DecimalPlaces INTEGER DEFAULT 2, | |