IP2Location™ Country Multilingual Database

Multilingual
Registration required
English

IP2Location™ Country Multilingual Database is a free database version for your download. The database can be used to display the country name for up to 81 different languages. And, it is currently available in CSV text file (comma delimited).

You may download and use the IP2Location™ Country Multilingual Database in your personal and commercial project, with attribution is required by mentioning the use of this data as follows, "The IP geolocation data is provided by http://www.ip2location.com", on webpage and in the documentation or advertising.

 

Product Features
Last Update 07/12/2016
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.

 

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 http://www.ip2location.com", on webpage and in the documentation or advertising.

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

 

Languages Supported
Language Code Language Name
AFAFRIKAANS
AMAMHARIC
ARARABIC
AZAZERBAIJANI
BEBELARUSIAN
BGBULGARIAN
BNBENGALI
BOTIBETAN STANDARD
CACATALAN
CSCZECH
CYWELSH
DADANISH
DEGERMAN
EEEWE
ELGREEK
ENENGLISH
EOESPERANTO
ESSPANISH
ETESTONIAN
EUBASQUE
FAPERSIAN
FIFINNISH
FOFAROESE
FRFRENCH
GAIRISH
GLGALICIAN
GUGUJARATI
HEHEBREW
HIHINDI
HRCROATIAN
HUHUNGARIAN
HYARMENIAN
IAINTERLINGUA
IDINDONESIAN
ISICELANDIC
ITITALIAN
JAJAPANESE
KAGEORGIAN
KIKIKUYU
KMKHMER
KNKANNADA
KOKOREAN
LGGANDA
LOLAO
LTLITHUANIAN
LVLATVIAN
MKMACEDONIAN
MLMALAYALAM
MRMARATHI
MSMALAY
MTMALTESE
MYBURMESE
NBNORWEGIAN BOKMAL
NENEPALI
NLDUTCH
NNNORWEGIAN NYNORSK
NONORWEGIAN
ORORIYA
PLPOLISH
PTPORTUGUESE
RMROMANSH
ROROMANIAN
RURUSSIAN
SENORTHERN SAMI
SKSLOVAK
SLSLOVENE
SNSHONA
SQALBANIAN
SRSERBIAN
SVSWEDISH
TATAMIL
TETELUGU
THTHAI
TITIGRINYA
TLTAGALOG
TRTURKISH
UKUKRAINIAN
URURDU
VIVIETNAMESE
ZH-CNCHINESE SIMPLIFIED
ZH-TWCHINESE TRADITIONAL

 

Country Name (English)
Country CodeCountry Name
AFAfghanistan
AXAland Islands
ALAlbania
DZAlgeria
ASAmerican Samoa
ADAndorra
AOAngola
AIAnguilla
AQAntarctica
AGAntigua and Barbuda
ARArgentina
AMArmenia
AWAruba
AUAustralia
ATAustria
AZAzerbaijan
BSBahamas
BHBahrain
BDBangladesh
BBBarbados
BYBelarus
BEBelgium
BZBelize
BJBenin
BMBermuda
BTBhutan
BOBolivia, Plurinational State of
BQBonaire, Sint Eustatius and Saba
BABosnia and Herzegovina
BWBotswana
BVBouvet Island
BRBrazil
IOBritish Indian Ocean Territory
BNBrunei Darussalam
BGBulgaria
BFBurkina Faso
BIBurundi
KHCambodia
CMCameroon
CACanada
CVCape Verde
KYCayman Islands
CFCentral African Republic
TDChad
CLChile
CNChina
CXChristmas Island
CCCocos (Keeling) Islands
COColombia
KMComoros
CGCongo
CDCongo, The Democratic Republic of The
CKCook Islands
CRCosta Rica
CICote D'ivoire
HRCroatia
CUCuba
CWCuracao
CYCyprus
CZCzech Republic
DKDenmark
DJDjibouti
DMDominica
DODominican Republic
ECEcuador
EGEgypt
SVEl Salvador
GQEquatorial Guinea
EREritrea
EEEstonia
ETEthiopia
FKFalkland Islands (Malvinas)
FOFaroe Islands
FJFiji
FIFinland
FRFrance
GFFrench Guiana
PFFrench Polynesia
TFFrench Southern Territories
GAGabon
GMGambia
GEGeorgia
DEGermany
GHGhana
GIGibraltar
GRGreece
GLGreenland
GDGrenada
GPGuadeloupe
GUGuam
GTGuatemala
GGGuernsey
GNGuinea
GWGuinea-Bissau
GYGuyana
HTHaiti
HMHeard Island and Mcdonald Islands
VAHoly See (Vatican City State)
HNHonduras
HKHong Kong
HUHungary
ISIceland
INIndia
IDIndonesia
IRIran, Islamic Republic of
IQIraq
IEIreland
IMIsle of Man
ILIsrael
ITItaly
JMJamaica
JPJapan
JEJersey
JOJordan
KZKazakhstan
KEKenya
KIKiribati
KPKorea, Democratic People's Republic of
KRKorea, Republic of
KWKuwait
KGKyrgyzstan
LALao People's Democratic Republic
LVLatvia
LBLebanon
LSLesotho
LRLiberia
LYLibya
LILiechtenstein
LTLithuania
LULuxembourg
MOMacao
MKMacedonia, The Former Yugoslav Republic of
MGMadagascar
MWMalawi
MYMalaysia
MVMaldives
MLMali
MTMalta
MHMarshall Islands
MQMartinique
MRMauritania
MUMauritius
YTMayotte
MXMexico
FMMicronesia, Federated States of
MDMoldova, Republic of
MCMonaco
MNMongolia
MEMontenegro
MSMontserrat
MAMorocco
MZMozambique
MMMyanmar
NANamibia
NRNauru
NPNepal
NLNetherlands
NCNew Caledonia
NZNew Zealand
NINicaragua
NENiger
NGNigeria
NUNiue
NFNorfolk Island
MPNorthern Mariana Islands
NONorway
OMOman
PKPakistan
PWPalau
PSPalestine, State of
PAPanama
PGPapua New Guinea
PYParaguay
PEPeru
PHPhilippines
PNPitcairn
PLPoland
PTPortugal
PRPuerto Rico
QAQatar
REReunion
RORomania
RURussian Federation
RWRwanda
BLSaint Barthelemy
SHSaint Helena, Ascension and Tristan Da Cunha
KNSaint Kitts and Nevis
LCSaint Lucia
MFSaint Martin (French Part)
PMSaint Pierre and Miquelon
VCSaint Vincent and The Grenadines
WSSamoa
SMSan Marino
STSao Tome and Principe
SASaudi Arabia
SNSenegal
RSSerbia
SCSeychelles
SLSierra Leone
SGSingapore
SXSint Maarten (Dutch Part)
SKSlovakia
SISlovenia
SBSolomon Islands
SOSomalia
ZASouth Africa
GSSouth Georgia and The South Sandwich Islands
SSSouth Sudan
ESSpain
LKSri Lanka
SDSudan
SRSuriname
SJSvalbard and Jan Mayen
SZSwaziland
SESweden
CHSwitzerland
SYSyrian Arab Republic
TWTaiwan, Province of China
TJTajikistan
TZTanzania, United Republic of
THThailand
TLTimor-Leste
TGTogo
TKTokelau
TOTonga
TTTrinidad and Tobago
TNTunisia
TRTurkey
TMTurkmenistan
TCTurks and Caicos Islands
TVTuvalu
UGUganda
UAUkraine
AEUnited Arab Emirates
GBUnited Kingdom
USUnited States
UMUnited States Minor Outlying Islands
UYUruguay
UZUzbekistan
VUVanuatu
VEVenezuela, Bolivarian Republic of
VNViet Nam
VGVirgin Islands, British
VIVirgin Islands, U.S.
WFWallis and Futuna
EHWestern Sahara
YEYemen
ZMZambia
ZWZimbabwe

 

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.