ip2location facebbook  ip2location twitter  ip2location google+ ip2location github

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 05/30/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
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),
    PRIMARY KEY (`country_alpha2_code`,`region_name`,`city_name`)
) 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.

 

Languages Supported
Country Code Country Name Language Code Language Name
ADANDORRACACATALAN
AEUNITED ARAB EMIRATESARARABIC
AFAFGHANISTANFAPERSIAN
AGANTIGUA AND BARBUDAENENGLISH
AIANGUILLAENENGLISH
ALALBANIASQALBANIAN
AMARMENIARURUSSIAN
AOANGOLAPTPORTUGUESE
AQANTARCTICAENENGLISH
ARARGENTINAESSPANISH
ASAMERICAN SAMOAENENGLISH
ATAUSTRIADEGERMAN
AUAUSTRALIAENENGLISH
AWARUBANLDUTCH
AXALAND ISLANDSSVSWEDISH
AZAZERBAIJANAZAZERBAIJANI
BABOSNIA AND HERZEGOVINAHRCROATIAN
BBBARBADOSENENGLISH
BDBANGLADESHBNBENGALI
BEBELGIUMNLDUTCH
BFBURKINA FASOFRFRENCH
BGBULGARIAENENGLISH
BHBAHRAINARARABIC
BIBURUNDIFRFRENCH
BJBENINFRFRENCH
BLSAINT BARTHELEMYFRFRENCH
BMBERMUDAENENGLISH
BNBRUNEI DARUSSALAMMSMalay
BOBOLIVIA, PLURINATIONAL STATE OFESSPANISH
BQBONAIRE, SINT EUSTATIUS AND SABAENENGLISH
BRBRAZILPTPORTUGUESE
BSBAHAMASENENGLISH
BTBHUTANENENGLISH
BWBOTSWANAENENGLISH
BYBELARUSRURUSSIAN
BZBELIZEENENGLISH
CACANADAENENGLISH
CCCOCOS (KEELING) ISLANDSENENGLISH
CDCONGO, THE DEMOCRATIC REPUBLIC OF THEENENGLISH
CFCENTRAL AFRICAN REPUBLICFRFRENCH
CGCONGOENENGLISH
CHSWITZERLANDDEGERMAN
CICOTE D'IVOIREENENGLISH
CKCOOK ISLANDSENENGLISH
CLCHILEESSPANISH
CMCAMEROONFRFRENCH
CNCHINAZH-CNCHINESE SIMPLIFIED
COCOLOMBIAESSPANISH
CRCOSTA RICAESSPANISH
CUCUBAESSPANISH
CVCAPE VERDEPTPORTUGUESE
CWCURACAONLDUTCH
CXCHRISTMAS ISLANDENENGLISH
CYCYPRUSTRTURKISH
CZCZECH REPUBLICCSCZECH
DEGERMANYDEGERMAN
DJDJIBOUTIFRFRENCH
DKDENMARKDADANISH
DMDOMINICAENENGLISH
DODOMINICAN REPUBLICESSPANISH
DZALGERIAARARABIC
ECECUADORESSPANISH
EEESTONIAETESTONIAN
EGEGYPTARARABIC
EHWESTERN SAHARAESSPANISH
ERERITREAENENGLISH
ESSPAINESSPANISH
ETETHIOPIAAMAMHARIC
FIFINLANDFIFINNISH
FJFIJIENENGLISH
FKFALKLAND ISLANDS (MALVINAS)ENENGLISH
FMMICRONESIA, FEDERATED STATES OFENENGLISH
FOFAROE ISLANDSFOFAROESE
FRFRANCEFRFRENCH
GAGABONFRFRENCH
GBUNITED KINGDOMENENGLISH
GDGRENADAENENGLISH
GEGEORGIAKAGEORGIAN
GFFRENCH GUIANAFRFRENCH
GGGUERNSEYFRFRENCH
GHGHANAENENGLISH
GIGIBRALTARESSPANISH
GLGREENLANDENENGLISH
GMGAMBIAENENGLISH
GNGUINEAFRFRENCH
GPGUADELOUPEFRFRENCH
GQEQUATORIAL GUINEAESSPANISH
GRGREECEELGREEK
GSSOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDSENENGLISH
GTGUATEMALAESSPANISH
GUGUAMENENGLISH
GWGUINEA-BISSAUPTPORTUGUESE
GYGUYANAENENGLISH
HKHONG KONGZHCHINESE
HNHONDURASESSPANISH
HRCROATIAHRCROATIAN
HTHAITIHTHAITIAN
HUHUNGARYHUHUNGARIAN
IDINDONESIAIDINDONESIAN
IEIRELANDGAIRISH
ILISRAELHEHEBREW
IMISLE OF MANENENGLISH
ININDIAHIHINDI
IOBRITISH INDIAN OCEAN TERRITORYENENGLISH
IQIRAQARARABIC
IRIRAN, ISLAMIC REPUBLIC OFFAPERSIAN
ISICELANDISICELANDIC
ITITALYITITALIAN
JEJERSEYFRFRENCH
JMJAMAICAENENGLISH
JOJORDANARARABIC
JPJAPANJAJAPANESE
KEKENYAENENGLISH
KGKYRGYZSTANRURUSSIAN
KHCAMBODIAKHKHMER
KIKIRIBATIENENGLISH
KMCOMOROSARARABIC
KNSAINT KITTS AND NEVISENENGLISH
KPKOREA, DEMOCRATIC PEOPLE'S REPUBLIC OFKOKOREAN
KRKOREA, REPUBLIC OFKOKOREAN
KWKUWAITARARABIC
KYCAYMAN ISLANDSENENGLISH
KZKAZAKHSTANRURUSSIAN
LALAO PEOPLE'S DEMOCRATIC REPUBLICLOLAO
LBLEBANONARARABIC
LCSAINT LUCIAENENGLISH
LILIECHTENSTEINDEGERMAN
LKSRI LANKASISINHALA
LRLIBERIAENENGLISH
LSLESOTHOENENGLISH
LTLITHUANIALTLITHUANIAN
LULUXEMBOURGFRFRENCH
LVLATVIALVLATVIAN
LYLIBYAARARABIC
MAMOROCCOARARABIC
MCMONACOFRFRENCH
MDMOLDOVA, REPUBLIC OFROROMANIAN
MEMONTENEGROENENGLISH
MFSAINT MARTIN (FRENCH PART)ENENGLISH
MGMADAGASCARFRFRENCH
MHMARSHALL ISLANDSENENGLISH
MKMACEDONIA, THE FORMER YUGOSLAV REPUBLIC OFMKMACEDONIAN
MLMALIFRFRENCH
MMMYANMARMYBURMESE
MNMONGOLIARURUSSIAN
MOMACAOZHCHINESE
MPNORTHERN MARIANA ISLANDSENENGLISH
MQMARTINIQUEFRFRENCH
MRMAURITANIAARARABIC
MSMONTSERRATENENGLISH
MTMALTAMTMALTESE
MUMAURITIUSFRFRENCH
MVMALDIVESENENGLISH
MWMALAWIENENGLISH
MXMEXICOESSPANISH
MYMALAYSIAMSMALAY
MZMOZAMBIQUEPTPORTUGUESE
NANAMIBIAENENGLISH
NCNEW CALEDONIAFRFRENCH
NENIGERFRFRENCH
NFNORFOLK ISLANDENENGLISH
NGNIGERIAENENGLISH
NINICARAGUAESSPANISH
NLNETHERLANDSNLDUTCH
NONORWAYNONORWEGIAN
NPNEPALNENEPALI
NRNAURUENENGLISH
NUNIUEENENGLISH
NZNEW ZEALANDENENGLISH
OMOMANARARABIC
PAPANAMAESSPANISH
PEPERUESSPANISH
PFFRENCH POLYNESIAFRFRENCH
PGPAPUA NEW GUINEAENENGLISH
PHPHILIPPINESENENGLISH
PKPAKISTANURURDU
PLPOLANDPLPOLISH
PMSAINT PIERRE AND MIQUELONFRFRENCH
PNPITCAIRNENENGLISH
PRPUERTO RICOESSPANISH
PSPALESTINE, STATE OFENENGLISH
PTPORTUGALPTPORTUGUESE
PWPALAUENENGLISH
PYPARAGUAYESSPANISH
QAQATARARARABIC
REREUNIONENENGLISH
ROROMANIAROROMANIAN
RSSERBIARURUSSIAN
RURUSSIAN FEDERATIONRURUSSIAN
RWRWANDAENENGLISH
SASAUDI ARABIAARARABIC
SBSOLOMON ISLANDSENENGLISH
SCSEYCHELLESENENGLISH
SDSUDANARARABIC
SESWEDENSVSWEDISH
SGSINGAPOREENENGLISH
SHSAINT HELENA, ASCENSION AND TRISTAN DA CUNHAENENGLISH
SISLOVENIASLSLOVENE
SJSVALBARD AND JAN MAYENNONORWEGIAN
SKSLOVAKIASKSLOVAK
SLSIERRA LEONEENENGLISH
SMSAN MARINOITITALIAN
SNSENEGALFRFRENCH
SOSOMALIAARARABIC
SRSURINAMENLDUTCH
SSSOUTH SUDANENENGLISH
STSAO TOME AND PRINCIPEPTPORTUGUESE
SVEL SALVADORESSPANISH
SXSINT MAARTEN (DUTCH PART)ENENGLISH
SYSYRIAN ARAB REPUBLICARARABIC
SZSWAZILANDENENGLISH
TCTURKS AND CAICOS ISLANDSENENGLISH
TDCHADFRFRENCH
TFFRENCH SOUTHERN TERRITORIESFRFRENCH
TGTOGOFRFRENCH
THTHAILANDTHTHAI
TJTAJIKISTANFAPERSIAN
TKTOKELAUENENGLISH
TLTIMOR-LESTEPTPORTUGUESE
TMTURKMENISTANRURUSSIAN
TNTUNISIAARARABIC
TOTONGAENENGLISH
TRTURKEYTRTURKISH
TTTRINIDAD AND TOBAGOENENGLISH
TVTUVALUENENGISH
TWTAIWAN, PROVINCE OF CHINAZN-TWCHINESE TRADITIONAL
TZTANZANIA, UNITED REPUBLIC OFENENGLISH
UAUKRAINERURUSSIAN
UGUGANDAENENGLISH
UMUNITED STATES MINOR OUTLYING ISLANDSENENGLISH
USUNITED STATESENENGLISH
UYURUGUAYESSPANISH
UZUZBEKISTANUZUZBEK
VAHOLY SEE (VATICAN CITY STATE)ENENGLISH
VCSAINT VINCENT AND THE GRENADINESENENGLISH
VEVENEZUELA, BOLIVARIAN REPUBLIC OFESSPANISH
VGVIRGIN ISLANDS, BRITISHENENGLISH
VIVIRGIN ISLANDS, U.S.ENENGLISH
VNVIET NAMVIVIETNAMESE
VUVANUATUFRFRENCH
WFWALLIS AND FUTUNAFRFRENCH
WSSAMOAENENGLISH
YEYEMENARARABIC
YTMAYOTTEFRFRENCH
ZASOUTH AFRICAAFAFRIKAANS
ZMZAMBIAENENGLISH
ZWZIMBABWEENENGLISH

 

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.