xls.translations
The xls.translations table allows configuring the following features:
- Translated names, descriptions, and comments of objects
- Translated names and descriptions of columns and parameters
SaveToDB and DBEdit users can choose the desired language using the Options dialog box.
DBGate and ODataDB users can choose the desired language via the language segment of the service URL.
The table has the following structure:
| ID | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | LANGUAGE_NAME | TRANSLATED_NAME | TRANSLATED_DESC | TRANSLATED_COMMENT |
|---|---|---|---|---|---|---|---|
| <schema> | <object name> | <language> | <translated name> | <description> | <comment> | ||
| <schema> | <object name> | <column name> | <language> | <translated name> | <description> | ||
| <schema> | <object name> | <parameter name> | <language> | <translated name> | <description> | ||
| <schema> | <column name> | <language> | <translated name> | <description> | |||
| <schema> | <parameter name> | <language> | <translated name> | <description> |
Use rows with the blank TABLE_NAME to define the default translation of columns and parameters of the schema objects.
The LANGUAGE_NAME column must contain a two-character code of a data language like "en" or "fr".
See details: