Configuring database sort in collations.xml

Guidewire uses collations.xml as a lookup file. To access collations.xml, navigate in the Guidewire Studio Projects window to configuration > config > Localizations. PolicyCenter uses the following definitions in this file to look up the sort collation name and apply it:

  • The application localization code
  • The strength attribute value from the <SortCollation> element in language_languageCode.xml
  • The database management system (DBMS) type

PolicyCenter primarily uses these values to look up the sort collation. For example, suppose that the following are all true:

  • The database is Oracle.
  • The user language is German.
  • The strength value of SortCollation in language_de_DE.xml is set to secondary.

PolicyCenter then looks at the following for instructions on how to set NLS_SORT for Oracle sessions and sets it to GERMAN_CI.

<Database type="ORACLE">
  ...
  <Collation locale="de" primary="GERMAN_AI" secondary="GERMAN_CI" tertiary="GERMAN"/>
...

Collation in QuickStart (H2 development) database

To specify collation in file collations.xml for an H2 database, use a standard locale name format, for example de_DE for Germany, ja_JP for Japan.