• Your shopping cart is empty!
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.

English

Download
Free download

Multilingual

Download
Registration required
Features
Last Update 18 December, 2018
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

Attribution is 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.

IP2Location™ and IP2Proxy™ are registered trademarks of HEXASOFT. All other trademarks are the properties of their respective owners.

Languages Supported
Language Code Language Name
AF AFRIKAANS
AM AMHARIC
AR ARABIC
AZ AZERBAIJANI
BE BELARUSIAN
Show More »
Country Name (English)
Country Code Country Name
AF Afghanistan
AX Aland Islands
AL Albania
DZ Algeria
AS American Samoa
Show More »