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 | 26 April, 2021 |
---|---|
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 |
---|---|
AD | Andorra |
AE | United Arab Emirates |
AF | Afghanistan |
AG | Antigua and Barbuda |
AI | Anguilla |
Show More » |