• 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
Free with registration
Features
Last Update 04 June, 2019
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 »
Country Name (English)
Country Code Country Name
AF Afghanistan
AX Aland Islands
AL Albania
DZ Algeria
AS American Samoa
Show More »