Configuring database sort in language_languageCode.xml

For optional use, the <SortCollation> subelement of the <GWLanguage> element in language_languageCode.xml controls specialized sorting behavior. To access the localization files, open Guidewire Studio™ and navigate in the Projects window to configuration > config > Localizations.

The <SortCollation> element has a single strength attribute that determines collation strength—how PolicyCenter sorting algorithms handle accents and case during the sorting of character data for the following:

• Sorting of in-memory data
• Sorting of data in the database

The strength attribute, which defaults to secondary, can take the following values:

• primary
• secondary
• tertiary

The specific meaning of the strength attribute depends on the language. In general:

• A strength of primary instructs the search and sort algorithms to consider just the base, or primary letter, and to ignore other attributes, such as case or accents. With this setting, the collation rules consider the characters e and E to have the same weight.
• A strength of secondary instructs the search and sort algorithms to consider character weight and accent differences. This value is the default setting. With this setting, the collation rules consider the characters e and è to be different and order them differently.
• A strength of tertiary instructs the search and sort algorithms to consider character weight, accent differences, and case. With this setting, the collation rules consider the characters e and è and E to be different and order them differently.

The following list describes these differences.

Strength	Case-sensitive	Accent-sensitive
primary	No	No
secondary	No	Yes
tertiary	Yes	Yes