ip2location facebbook  ip2location twitter  ip2location google+ ip2location github

IP2Location™ Region Multilingual Database

For customer only

IP2Location™ Region Multilingual Database provides you the world region names with 100% fully translated into native language and it is absolutely FREE offered for our valued customer. The database is provided in CSV format, so that you can easily import into any database of your choice.

 

Languages Supported
Language Code Language Name
ZH-CNChinese Simplified
ZH-TWChinese Traditional
ESSpanish
PTPortuguese

 

Product Features
Last Update 11/19/2018
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
lang_code VARCHAR(5) Language code
lang_name VARCHAR(50) Language name
lang_region_name VARCHAR(200) Region name in native language.

 

MySQL Statement

CREATE TABLE `ip2location_region_multilingual`(
	`country_alpha2_code` VARCHAR(2),
	`country_numeric_code` VARCHAR(3),
	`country_name` VARCHAR(64),
	`region_code` VARCHAR(10),
	`region_name` VARCHAR(128),
	`lang_code` VARCHAR(5),
	`lang_name` VARCHAR(50),
	`lang_region_name` VARCHAR(200),
    PRIMARY KEY (`country_alpha2_code`,`region_name`)
) CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-COUNTRY-REGION.CSV' INTO TABLE `ip2location_region_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="https://www.ip2location.com">https://www.ip2location.com</a>
Copy & paste this text as HTML.