The Translated Text field is a special field type which provides translations of different content depending on the user locale. This field operates as the text field, and is used throughout the system.
Administrators information
English translations are stored in the master table, the Translations (sys_translation) table stores localized texts. The Translation table contains several entries of a translated field – one per every language provided.
The Translated Text table
Translations for fields with the Translated Text field type are saved in the Translations (sys_translation) table.
Translated text form fields
| Field | Description |
|---|
| column_id | The ID of the column containing translated text. |
| record_id | The ID of the record containing translated text. |
| language_id | The ID of the language the text translated into. |
| value | The displayed translated text. |
The English text in the master table and the translated text are linked to each other with "record_id-language_id" fields. These fields' values are used when looking for the translation of the English language text of the specified field, and if found, it is taken as a translation. The same goes for translations to any other language.
