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.
Last Update | 02 December, 2020 |
---|---|
Database Format | CSV Text File (Comma Delimited) |
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;
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".
Language Code | Language Name |
---|---|
AF | AFRIKAANS |
AM | AMHARIC |
AR | ARABIC |
AZ | AZERBAIJANI |
BE | BELARUSIAN |
Show More » |
Country Code | Country Name |
---|---|
AF | Afghanistan |
AX | Aland Islands |
AL | Albania |
DZ | Algeria |
AS | American Samoa |
Show More » |