FREE
IP2Location™ Country Multilingual Database
IP2Location™ Country Multilingual Database is a free database for your download. The database can be used to display the country name in up to 81 different languages. And, it is currently available in a CSV text file (comma delimited).
You may download and use the IP2Location™ Country Multilingual Database in your personal and commercial project, with attribution being required by mentioning the use of this data as follows, "The IP geolocation data is provided by https://www.ip2location.com", on your webpage and in the documentation or advertising.
Features
| Last Update | 06 December, 2023 |
|---|---|
| Database Format | CSV Text File (Comma Delimited) |
Database Fields
| Name | Type | Description |
|---|---|---|
| lang | VARCHAR(5) | Language code based on ISO 639, except Chinese Simplified (ZH-CN) and Chinese Traditional (ZH-TW). |
| lang_name | VARCHAR(50) | Language Name based on ISO 639. |
| country_alpha2_code | CHAR(2) | Two-character country code based on ISO 3166. |
| country_alpha3_code | CHAR(3) | Three-character country code based on ISO 3166. |
| country_numeric_code | CHAR(3) | Three-character country numeric code based on ISO 3166. |
| country_name | VARCHAR(200) | Country name based on ISO 3166. |
Sample Database
"lang","lang_name","country_alpha2_code","country_alpha3_code","country_numeric_code","country_name"
"EN","ENGLISH","AD","AND","20","Andorra"
"EN","ENGLISH","AE","ARE","784","United Arab Emirates"
"EN","ENGLISH","AF","AFG","4","Afghanistan"
"EN","ENGLISH","AG","ATG","28","Antigua and Barbuda"
"EN","ENGLISH","AI","AIA","660","Anguilla"MySQL Statement
CREATE TABLE `ip2location_country_multilingual`(
`lang` VARCHAR(5),
`lang_name` VARCHAR(50),
`country_alpha2_code` CHAR(2),
`country_alpha3_code` CHAR(3),
`country_numeric_code` CHAR(3),
`country_name` VARCHAR(200),
INDEX `idx_lang` (`lang`),
INDEX `idx_country_alpha2_code` (`country_alpha2_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
LOAD DATA LOCAL
INFILE 'IP2LOCATION-COUNTRY-MULTILINGUAL.CSV' INTO TABLE `ip2location_country_multilingual`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES; License Information
This works is licensed under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0).
It is free for personal or commercial use with attribution required by mentioning the use of this works as follows:
This site or product includes IP2Location™ Country Multilingual Database which available from https://www.ip2location.com".
Languages Supported
| Language Code | Language Name |
|---|---|
| AF | AFRIKAANS |
| AM | AMHARIC |
| AR | ARABIC |
| AZ | AZERBAIJANI |
| BE | BELARUSIAN |
| Show More » | |
| BG | BULGARIAN |
| BN | BENGALI |
| BO | TIBETAN STANDARD |
| CA | CATALAN |
| CS | CZECH |
| CY | WELSH |
| DA | DANISH |
| DE | GERMAN |
| EE | EWE |
| EL | GREEK |
| EN | ENGLISH |
| EO | ESPERANTO |
| ES | SPANISH |
| ET | ESTONIAN |
| EU | BASQUE |
| FA | PERSIAN |
| FI | FINNISH |
| FO | FAROESE |
| FR | FRENCH |
| GA | IRISH |
| GL | GALICIAN |
| GU | GUJARATI |
| HE | HEBREW |
| HI | HINDI |
| HR | CROATIAN |
| HU | HUNGARIAN |
| HY | ARMENIAN |
| IA | INTERLINGUA |
| ID | INDONESIAN |
| IS | ICELANDIC |
| IT | ITALIAN |
| JA | JAPANESE |
| KA | GEORGIAN |
| KI | KIKUYU |
| KM | KHMER |
| KN | KANNADA |
| KO | KOREAN |
| LG | GANDA |
| LO | LAO |
| LT | LITHUANIAN |
| LV | LATVIAN |
| MK | MACEDONIAN |
| ML | MALAYALAM |
| MR | MARATHI |
| MS | MALAY |
| MT | MALTESE |
| MY | BURMESE |
| NB | NORWEGIAN BOKMAL |
| NE | NEPALI |
| NL | DUTCH |
| NN | NORWEGIAN NYNORSK |
| NO | NORWEGIAN |
| OR | ORIYA |
| PL | POLISH |
| PT | PORTUGUESE |
| RM | ROMANSH |
| RO | ROMANIAN |
| RU | RUSSIAN |
| SE | NORTHERN SAMI |
| SK | SLOVAK |
| SL | SLOVENE |
| SN | SHONA |
| SQ | ALBANIAN |
| SR | SERBIAN |
| SV | SWEDISH |
| TA | TAMIL |
| TE | TELUGU |
| TH | THAI |
| TI | TIGRINYA |
| TL | TAGALOG |
| TR | TURKISH |
| UK | UKRAINIAN |
| UR | URDU |
| VI | VIETNAMESE |
| ZH-CN | CHINESE SIMPLIFIED |
| ZH-TW | CHINESE TRADITIONAL |
Country Name (English)
| Country Code | Country Name |
|---|---|
| AF | Afghanistan |
| AX | Aland Islands |
| AL | Albania |
| DZ | Algeria |
| AS | American Samoa |
| Show More » | |
| AD | Andorra |
| AO | Angola |
| AI | Anguilla |
| AQ | Antarctica |
| AG | Antigua and Barbuda |
| AR | Argentina |
| AM | Armenia |
| AW | Aruba |
| AU | Australia |
| AT | Austria |
| AZ | Azerbaijan |
| BS | Bahamas |
| BH | Bahrain |
| BD | Bangladesh |
| BB | Barbados |
| BY | Belarus |
| BE | Belgium |
| BZ | Belize |
| BJ | Benin |
| BM | Bermuda |
| BT | Bhutan |
| BO | Bolivia (Plurinational State of) |
| BQ | Bonaire, Sint Eustatius and Saba |
| BA | Bosnia and Herzegovina |
| BW | Botswana |
| BV | Bouvet Island |
| BR | Brazil |
| IO | British Indian Ocean Territory |
| BN | Brunei Darussalam |
| BG | Bulgaria |
| BF | Burkina Faso |
| BI | Burundi |
| CV | Cabo Verde |
| KH | Cambodia |
| CM | Cameroon |
| CA | Canada |
| KY | Cayman Islands |
| CF | Central African Republic |
| TD | Chad |
| CL | Chile |
| CN | China |
| CX | Christmas Island |
| CC | Cocos (Keeling) Islands |
| CO | Colombia |
| KM | Comoros |
| CG | Congo |
| CD | Congo (Democratic Republic of the) |
| CK | Cook Islands |
| CR | Costa Rica |
| CI | Cote d'Ivoire |
| HR | Croatia |
| CU | Cuba |
| CW | Curaçao |
| CY | Cyprus |
| CZ | Czechia |
| DK | Denmark |
| DJ | Djibouti |
| DM | Dominica |
| DO | Dominican Republic |
| EC | Ecuador |
| EG | Egypt |
| SV | El Salvador |
| GQ | Equatorial Guinea |
| ER | Eritrea |
| EE | Estonia |
| SZ | Eswatini |
| ET | Ethiopia |
| FK | Falkland Islands (Malvinas) |
| FO | Faroe Islands |
| FJ | Fiji |
| FI | Finland |
| FR | France |
| GF | French Guiana |
| PF | French Polynesia |
| TF | French Southern Territories |
| GA | Gabon |
| GM | Gambia |
| GE | Georgia |
| DE | Germany |
| GH | Ghana |
| GI | Gibraltar |
| GR | Greece |
| GL | Greenland |
| GD | Grenada |
| GP | Guadeloupe |
| GU | Guam |
| GT | Guatemala |
| GG | Guernsey |
| GN | Guinea |
| GW | Guinea-Bissau |
| GY | Guyana |
| HT | Haiti |
| HM | Heard Island and McDonald Islands |
| VA | Holy See |
| HN | Honduras |
| HK | Hong Kong |
| HU | Hungary |
| IS | Iceland |
| IN | India |
| ID | Indonesia |
| IR | Iran (Islamic Republic of) |
| IQ | Iraq |
| IE | Ireland |
| IM | Isle of Man |
| IL | Israel |
| IT | Italy |
| JM | Jamaica |
| JP | Japan |
| JE | Jersey |
| JO | Jordan |
| KZ | Kazakhstan |
| KE | Kenya |
| KI | Kiribati |
| KP | Korea (Democratic People's Republic of) |
| KR | Korea (Republic of) |
| KW | Kuwait |
| KG | Kyrgyzstan |
| LA | Lao People's Democratic Republic |
| LV | Latvia |
| LB | Lebanon |
| LS | Lesotho |
| LR | Liberia |
| LY | Libya |
| LI | Liechtenstein |
| LT | Lithuania |
| LU | Luxembourg |
| MO | Macao |
| MG | Madagascar |
| MW | Malawi |
| MY | Malaysia |
| MV | Maldives |
| ML | Mali |
| MT | Malta |
| MH | Marshall Islands |
| MQ | Martinique |
| MR | Mauritania |
| MU | Mauritius |
| YT | Mayotte |
| MX | Mexico |
| FM | Micronesia (Federated States of) |
| MD | Moldova (Republic of) |
| MC | Monaco |
| MN | Mongolia |
| ME | Montenegro |
| MS | Montserrat |
| MA | Morocco |
| MZ | Mozambique |
| MM | Myanmar |
| NA | Namibia |
| NR | Nauru |
| NP | Nepal |
| NL | Netherlands |
| NC | New Caledonia |
| NZ | New Zealand |
| NI | Nicaragua |
| NE | Niger |
| NG | Nigeria |
| NU | Niue |
| NF | Norfolk Island |
| MK | North Macedonia |
| MP | Northern Mariana Islands |
| NO | Norway |
| OM | Oman |
| PK | Pakistan |
| PW | Palau |
| PS | Palestine, State of |
| PA | Panama |
| PG | Papua New Guinea |
| PY | Paraguay |
| PE | Peru |
| PH | Philippines |
| PN | Pitcairn |
| PL | Poland |
| PT | Portugal |
| PR | Puerto Rico |
| QA | Qatar |
| RE | Reunion |
| RO | Romania |
| RU | Russian Federation |
| RW | Rwanda |
| BL | Saint Barthelemy |
| SH | Saint Helena, Ascension and Tristan da Cunha |
| KN | Saint Kitts and Nevis |
| LC | Saint Lucia |
| MF | Saint Martin (French Part) |
| PM | Saint Pierre and Miquelon |
| VC | Saint Vincent and the Grenadines |
| WS | Samoa |
| SM | San Marino |
| ST | Sao Tome and Principe |
| SA | Saudi Arabia |
| SN | Senegal |
| RS | Serbia |
| SC | Seychelles |
| SL | Sierra Leone |
| SG | Singapore |
| SX | Sint Maarten (Dutch Part) |
| SK | Slovakia |
| SI | Slovenia |
| SB | Solomon Islands |
| SO | Somalia |
| ZA | South Africa |
| GS | South Georgia and the South Sandwich Islands |
| SS | South Sudan |
| ES | Spain |
| LK | Sri Lanka |
| SD | Sudan |
| SR | Suriname |
| SJ | Svalbard and Jan Mayen |
| SE | Sweden |
| CH | Switzerland |
| SY | Syrian Arab Republic |
| TW | Taiwan (Province of China) |
| TJ | Tajikistan |
| TZ | Tanzania, United Republic of |
| TH | Thailand |
| TL | Timor-Leste |
| TG | Togo |
| TK | Tokelau |
| TO | Tonga |
| TT | Trinidad and Tobago |
| TN | Tunisia |
| TR | Turkey |
| TM | Turkmenistan |
| TC | Turks and Caicos Islands |
| TV | Tuvalu |
| UG | Uganda |
| UA | Ukraine |
| AE | United Arab Emirates |
| GB | United Kingdom of Great Britain and Northern Ireland |
| UM | United States Minor Outlying Islands |
| US | United States of America |
| UY | Uruguay |
| UZ | Uzbekistan |
| VU | Vanuatu |
| VE | Venezuela (Bolivarian Republic of) |
| VN | Viet Nam |
| VG | Virgin Islands (British) |
| VI | Virgin Islands (U.S.) |
| WF | Wallis and Futuna |
| EH | Western Sahara |
| YE | Yemen |
| ZM | Zambia |
| ZW | Zimbabwe |
