xls.translations
The xls.translations table lets you configure the following features:
- Translated names, descriptions, and comments for objects
- Translated names and descriptions for columns and parameters
Users of SaveToDB and DBEdit can select their preferred language through the Options dialog box.
DBGate and ODataDB users can specify their desired language in the language segment of the service URL.
The table structure is as follows:
| 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 a blank TABLE_NAME to define the default translations for columns and parameters of schema objects.
The LANGUAGE_NAME column should contain a two-character language code, such as "en" for English or "fr" for French.
For more details, check out the following resources: