Language Table

Language Table is a database table that contains the language data of the dictionary. DatabaseDictionary dictionary component uses this format. The format of the row is:

Field SQL Type
EnglishName VARCHAR(32)
NativeName VARCHAR(32)
PrimaryId SMALLINT
SubIds VARCHAR(32)
DefaultSubId SMALLINT
FontName VARCHAR(32)
FontSize SMALLINT
Options SMALLINT
Charset SMALLINT
CodePage SMALLINT
ISOLanguage CHAR(2)
ISOCountries VARCHAR(32)
ISODefaultCountry CHAR(2)

The dictionary components access the fields by the index. That's why the actual name of the column is not used.

Use Language Manager or your database tool to create and edit language files.

Example

The following SQL script creates a language table.

CREATE TABLE LanguageTable
(
  EnglishName VARCHAR(32),
  NativeName VARCHAR(32),
  PrimaryId SMALLINT,
  SubIds VARCHAR(32),
  DefaultSubId SMALLINT,
  FontName VARCHAR(32),
  FontName SMALLINT,
  Options SMALLINT,
  Charset SMALLINT,
  CodePage SMALLINT,
  ISOLanguage VARCHAR(2),
  ISOCountries VARCHAR(32),
  ISODefaultCountry VARCHAR(2)
);