Add collation information for an unsupported language

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • Add collation information for an unsupported language to enable sorting columns in lists according to the language.

    Avant de commencer

    Add a record for a language not provided by an internationalization (I18N) plugin to associate new translations with and translate content into that language. For more information, see Translating to an unsupported language.

    Role required: admin

    Pourquoi et quand exécuter cette tâche

    Collation information must come from the underlying Relational Database Management System (RDBMS) used by the instance: MariaDB, RaptorDB, or Oracle. To determine which RDBMS an instance uses, navigate to All > System Diagnostics > Database > Information. Refer to the documentation provided by the RDBMS to determine if the database includes a collation for a given language and the name of the collation.

    Procédure

    1. In the navigation filter, enter sys_db_collation_info.list.
    2. Select New.
    3. On the form, fill in the fields.
      Tableau 1. DB Collation Info form
      Field Description
      Language The BCP 47 code for the language.
      Collation Name The name of the collation provided by the Relational Database Management System (RDBMS).
      Application The application scope.
      Database The Relational Database Management System (RDBMS) to which the collation applies: MariaDB, RaptorDB, or Oracle.
    4. Select Submit.

    Résultats

    When sorting columns according to the session language is enabled, users can sort columns according to the collation of the unsupported language. For more information, see Sorting according to the session language.