Database of languages
| Initial release: | |
|---|---|
| Current release: | |
| Written in: | SQL (UTF-8) |
| Size: | 9251 bytes |
| Available in: | English, Icelandic, Spanish |
| Licence: | Database: ODbL Database contents: DbCL Documentation: CC BY 4.0 |
| Download: | Database-of-languages.zip |
The database of languages resource provides language codes.
Tables
iso_639_1
The iso_639_1 table contains all codes of languages considered by the ISO 639-1 standard. The language names can be added to the table separately by executing the respective SQL scripts included in the resource.
| Name | Type | Content | Reference |
|---|---|---|---|
| code | char(2) | ISO 693-1 alpha 2 code. | – |
| language_family | tinyint(3) | – | language_families.identifier |
language_families
The language_families table contains the language families of the languages considered by the ISO 639-1 standard.
| Name | Type | Content | Reference |
|---|---|---|---|
| identifier | tinyint(3) | Unique row identifier. | – |
| language_family | varchar(19) | Language family description. | – |
Directory contents
- Database of countries directory
- Data directory
- iso_639_1 file
- iso_639_1_eng file
- iso_639_1_isl file
- iso_639_1_spa file
- language_families file
- languages file
- Testing directory
- language_families.sql file
- Data directory
Data (directory)
The Data directory contains all SQL scripts that create and modify the databases.
iso_639_1.sql (file)
The iso_639_1.sql file contains the iso_639_1 table.
language_families.sql (file)
The language_families.sql file contains the language_families table.
languages.sql (file)
The languages.sql file creates the languages database.
Testing (directory)
The Testing directory contains files used for testing the solution during development.
Licence
The database of languages resource by eMedia Intellect is licensed under Open Database License. Any rights in individual contents of the database are licensed under Database Contents License.