IP2Location™ City Multilingual Database

For customer only

IP2Location™ City Multilingual Database is a free database offered for our valued customer. This database enables you to query the region and city name in their country's native language (Note: For country that have multiple native languages, only one language will be selected for our database inclusion). The database is provided in CSV format, so that you can easily import into any database of your choice.

 

Product Features
Last Update 09/29/2016
Database Format CSV Text File (Comma Delimited)

 

Database Fields
Name Type Description
country_alpha2_code VARCHAR(2) Two-character country code based on ISO 3166.
country_numeric_code VARCHAR(3) Numeric country code based on ISO 3166.
country_name VARCHAR(64) Country name based on ISO 3166.
region_code VARCHAR(10) Region code
region_name VARCHAR(128) Region name
city_name VARCHAR(128) City name
lang_code VARCHAR(5) Language code
lang_name VARCHAR(50) Language name
lang_region_name VARCHAR(200) Region name in native language based on language code.
lang_city_name VARCHAR(200) City name in native language based on language code.

 

MySQL Statement

CREATE TABLE `ip2location_city_multilingual`(
	`country_alpha2_code` VARCHAR(2),
	`country_numeric_code` VARCHAR(3),
	`country_name` VARCHAR(64),
	`region_code` VARCHAR(10),
	`region_name` VARCHAR(128),
	`city_name` VARCHAR(128),
	`lang_code` VARCHAR(5),
	`lang_name` VARCHAR(50),
	`lang_region_name` VARCHAR(200),
	`lang_city_name` VARCHAR(200),
	INDEX `idx_country_alpha2_code` (`country_alpha2_code`),
	INDEX `idx_region_name` (`region_name`),
	INDEX `idx_city_name` (`city_name`),
	INDEX `idx_lang_code` (`lang_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-COUNTRY-REGION-CITY.CSV' INTO TABLE `ip2location_city_multilingual`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

 

License Information

IP2Location™ is a registered trademark of HEXASOFT. All other trademarks are the property of their respective owners.

 

Thank you for downloading

Sharing this great stuff to your friends!

Or share it on your blog or web page:

Free IP2Location geolocation resources available at <a href="http://www.ip2location.com">http://www.ip2location.com</a>
Copy & paste this text as HTML.