There are no notfications.

Database table of languages

Database table of languages
Initial release:
Current release:
Written in: SQL (UTF-8)
Size: 8951 bytes
Available in: English, Icelandic, Spanish
Licence: Database: ODbL
Database contents: DbCL
Documentation: CC BY 4.0
Download: Database-table-of-languages.zip

The database table 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.

Table columns
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.

Table columns
Name Type Content Reference
identifier tinyint(3) Unique row identifier.
language_family varchar(19) Language family description.

Directory contents

Directory listing
  • Database table 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
    • Testing directory
      • language_families.sql file

Data (directory)

The Data directory contains all SQL scripts that create and modify the database tables.

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.

Testing (directory)

The Testing directory contains files used for testing the solution during development.

Licence

The database table 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.