IP2Location™ Continent Multilingual Database
IP2Location™ Continent Multilingual Database is a free database version for your download. The database contains the continent names in up to 81 languages. It is available in the CSV format (comma delimited).
You may download and use the IP2Location™ Continent 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 also in the documentation or advertising.
Last Update | 04 June, 2019 |
---|---|
Database Format | CSV Text File (Comma Delimited) |
Name | Type | Description |
---|---|---|
lang | VARCHAR(5) | Language code based on ISO 639, except Chinese Simplified (ZH-CN) and Chinese Traditional (ZH-TW). |
country_alpha2_code | CHAR(2) | Two-character country code based on ISO 3166. |
continent_code | CHAR(2) | Two-character continent code. |
continent | VARCHAR(50) | Continent name. |
Sample Database
"lang","country_alpha2_code","continent_code","continent"
"EN","AD","EU","Europe"
"EN","AE","AS","Asia"
"EN","AF","AS","Asia"
"EN","AG","NA","North America"
"EN","AI","NA","North America"
MySQL Statement
CREATE TABLE `ip2location_continent_multilingual`(
`lang` VARCHAR(5),
`country_alpha2_code` CHAR(2),
`continent_code` CHAR(2),
`continent` VARCHAR(50),
INDEX `idx_lang` (`lang`),
INDEX `idx_country_alpha2_code` (`country_alpha2_code`),
INDEX `idx_continent_code` (`continent_code`),
INDEX `idx_continent` (`continent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
LOAD DATA LOCAL
INFILE 'IP2LOCATION-CONTINENT-MULTILINGUAL.CSV' INTO TABLE `ip2location_continent_multilingual`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
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™ Continent Multilingual Database which available from https://www.ip2location.com."
Language Code | Language Name |
---|---|
AF | AFRIKAANS |
AM | AMHARIC |
AR | ARABIC |
AZ | AZERBAIJANI |
BE | BELARUSIAN |
Show More » | |
BG | BULGARIAN |
BN | BENGALI |
BO | TIBETAN STANDARD |
CA | CATALAN |
CS | CZECH |
CY | WELSH |
DA | DANISH |
DE | GERMAN |
EE | EWE |
EL | GREEK |
EN | ENGLISH |
EO | ESPERANTO |
ES | SPANISH |
ET | ESTONIAN |
EU | BASQUE |
FA | PERSIAN |
FI | FINNISH |
FO | FAROESE |
FR | FRENCH |
GA | IRISH |
GL | GALICIAN |
GU | GUJARATI |
HE | HEBREW |
HI | HINDI |
HR | CROATIAN |
HU | HUNGARIAN |
HY | ARMENIAN |
IA | INTERLINGUA |
ID | INDONESIAN |
IS | ICELANDIC |
IT | ITALIAN |
JA | JAPANESE |
KA | GEORGIAN |
KI | KIKUYU |
KM | KHMER |
KN | KANNADA |
KO | KOREAN |
LG | GANDA |
LO | LAO |
LT | LITHUANIAN |
LV | LATVIAN |
MK | MACEDONIAN |
ML | MALAYALAM |
MR | MARATHI |
MS | MALAY |
MT | MALTESE |
MY | BURMESE |
NB | NORWEGIAN BOKMAL |
NE | NEPALI |
NL | DUTCH |
NN | NORWEGIAN NYNORSK |
NO | NORWEGIAN |
OR | ORIYA |
PL | POLISH |
PT | PORTUGUESE |
RM | ROMANSH |
RO | ROMANIAN |
RU | RUSSIAN |
SE | NORTHERN SAMI |
SK | SLOVAK |
SL | SLOVENE |
SN | SHONA |
SQ | ALBANIAN |
SR | SERBIAN |
SV | SWEDISH |
TA | TAMIL |
TE | TELUGU |
TH | THAI |
TI | TIGRINYA |
TL | TAGALOG |
TR | TURKISH |
UK | UKRAINIAN |
UR | URDU |
VI | VIETNAMESE |
ZH-CN | CHINESE SIMPLIFIED |
ZH-TW | CHINESE TRADITIONAL |
Continent Code | Continent Name |
---|---|
AF | AFRICA |
AN | ANTARCTICA |
AS | ASIA |
EU | EUROPE |
NA | NORTH AMERICA |
OC | OCEANIA |
SA | SOUTH AMERICA |