Home / Language & Localization / Languages

Languages

A standardized spoken language reference dataset intended for use in web and application development. It includes stable language identifiers and ISO 639 codes, with a schema designed for predictable querying and reuse. This dataset is suitable for localisation, user profiles, content tagging, and multilingual application support across different frameworks and storage formats.

Rows 60

Last updated 2025-12-23 19:22:01

Download

View raw SQL

languages.sql (6 KB)

Preview

id	name	native_name	iso_639_1	iso_639_2	iso_639_3	direction
1	Afrikaans	Afrikaans	af	afr	afr	ltr
2	Albanian	Shqip	sq	alb	sqi	ltr
3	Amharic	አማርኛ	am	amh	amh	ltr
4	Arabic	العربية	ar	ara	ara	rtl
5	Armenian (Eastern)	Հայերեն	hy	arm	hye	ltr
6	Armenian (Western)	Հայերեն	hy	arm	hyw	ltr
7	Azerbaijani (Azeri)	Azərbaycanca	az	aze	aze	ltr
8	Bassa				bsq	ltr
9	Belarusian	Беларуская	be	bel	bel	ltr
10	Bengali	বাংলা	bn	ben	ben	ltr
11	Bosnian	Bosanski	bs	bos	bos	ltr
12	Braille					ltr
13	Bulgarian	Български	bg	bul	bul	ltr
14	Burmese	မြန်မာစာ	my	bur	mya	ltr
15	Cambodian (Khmer)	ខ្មែរ	km	khm	khm	ltr
16	Cape Verde Creole					ltr
17	Cebuano	Cebuano			ceb	ltr
18	Chinese (Simplified)	简体中文	zh	chi	zho	ltr
19	Chinese (Traditional)	繁體中文	zh	chi	zho	ltr
20	Chuukese				chk	ltr
21	Croatian	Hrvatski	hr	hrv	hrv	ltr
22	Czech	Čeština	cs	cze	ces	ltr
23	Danish	Dansk	da	dan	dan	ltr
24	Dari	دری	fa	per	prs	rtl
25	Dutch	Nederlands	nl	dut	nld	ltr

Raw SQL

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `languages` (
  `id` bigint unsigned NOT NULL,
  `name` varchar(100) COLLATE utf8mb3_unicode_ci NOT NULL,
  `native_name` varchar(100) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `iso_639_1` char(2) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `iso_639_2` char(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `iso_639_3` char(3) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `direction` enum('ltr','rtl') COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'ltr',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
INSERT INTO `languages` VALUES (1,'Afrikaans','Afrikaans','af','afr','afr','ltr'),(2,'Albanian','Shqip','sq','alb','sqi','ltr'),(3,'Amharic','አማርኛ','am','amh','amh','ltr'),(4,'Arabic','العربية','ar','ara','ara','rtl'),(5,'Armenian (Eastern)','Հայերեն','hy','arm','hye','ltr'),(6,'Armenian (Western)','Հայերեն','hy','arm','hyw','ltr'),(7,'Azerbaijani (Azeri)','Azərbaycanca','az','aze','aze','ltr'),(8,'Bassa',NULL,NULL,NULL,'bsq','ltr'),(9,'Belarusian','Беларуская','be','bel','bel','ltr'),(10,'Bengali','বাংলা','bn','ben','ben','ltr'),(11,'Bosnian','Bosanski','bs','bos','bos','ltr'),(12,'Braille',NULL,NULL,NULL,NULL,'ltr'),(13,'Bulgarian','Български','bg','bul','bul','ltr'),(14,'Burmese','မြန်မာစာ','my','bur','mya','ltr'),(15,'Cambodian (Khmer)','ខ្មែរ','km','khm','khm','ltr'),(16,'Cape Verde Creole',NULL,NULL,NULL,NULL,'ltr'),(17,'Cebuano','Cebuano',NULL,NULL,'ceb','ltr'),(18,'Chinese (Simplified)','简体中文','zh','chi','zho','ltr'),(19,'Chinese (Traditional)','繁體中文','zh','chi','zho','ltr'),(20,'Chuukese',NULL,NULL,NULL,'chk','ltr'),(21,'Croatian','Hrvatski','hr','hrv','hrv','ltr'),(22,'Czech','Čeština','cs','cze','ces','ltr'),(23,'Danish','Dansk','da','dan','dan','ltr'),(24,'Dari','دری','fa','per','prs','rtl'),(25,'Dutch','Nederlands','nl','dut','nld','ltr'),(26,'English','English','en','eng','eng','ltr'),(27,'Estonian','Eesti','et','est','est','ltr'),(28,'Farsi (Persian)','فارسی','fa','per','fas','rtl'),(29,'Finnish','Suomi','fi','fin','fin','ltr'),(30,'Flemish','Vlaams','nl','dut','vls','ltr'),(31,'French (Canada)','Français','fr','fre','fra','ltr'),(32,'French (France)','Français','fr','fre','fra','ltr'),(33,'Fulani',NULL,NULL,NULL,'ful','ltr'),(34,'Georgian','ქართული','ka','geo','kat','ltr'),(35,'German','Deutsch','de','ger','deu','ltr'),(36,'Greek','Ελληνικά','el','gre','ell','ltr'),(37,'Gujarati','ગુજરાતી','gu','guj','guj','ltr'),(38,'Haitian Creole','Kreyòl','ht','hat','hat','ltr'),(39,'Hebrew','עברית','he','heb','heb','rtl'),(40,'Hindi','हिन्दी','hi','hin','hin','ltr'),(41,'Hungarian','Magyar','hu','hun','hun','ltr'),(42,'Icelandic','Íslenska','is','ice','isl','ltr'),(43,'Indonesian','Bahasa Indonesia','id','ind','ind','ltr'),(44,'Italian','Italiano','it','ita','ita','ltr'),(45,'Japanese','日本語','ja','jpn','jpn','ltr'),(46,'Korean','한국어','ko','kor','kor','ltr'),(47,'Norwegian','Norsk','no','nor','nor','ltr'),(48,'Polish','Polski','pl','pol','pol','ltr'),(49,'Portuguese (Brazil)','Português','pt','por','por','ltr'),(50,'Portuguese (Portugal)','Português','pt','por','por','ltr'),(51,'Russian','Русский','ru','rus','rus','ltr'),(52,'Spanish (Castilian)','Español','es','spa','spa','ltr'),(53,'Spanish (Latin American)','Español','es','spa','spa','ltr'),(54,'Swedish','Svenska','sv','swe','swe','ltr'),(55,'Thai','ไทย','th','tha','tha','ltr'),(56,'Turkish','Türkçe','tr','tur','tur','ltr'),(57,'Ukrainian','Українська','uk','ukr','ukr','ltr'),(58,'Urdu','اردو','ur','urd','urd','rtl'),(59,'Vietnamese','Tiếng Việt','vi','vie','vie','ltr'),(60,'Yoruba','Yorùbá','yo','yor','yor','ltr');
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Categories

Popular

Languages

Download

Preview

Raw SQL