Collation Settings of Customization

The collation property allows setting of locale-sensitive String comparison. If this property is activated, the default collation defined in i-net Clear Reports will be used. Otherwise the en_US Locale will be used to sort the data case-insensitive.

Default value: true

This property allows the setting of language (Locale e.g. en_US) which defines the collation rules of strings.
Note: To use this option please check that your database supports case sensitive comparison and applies same locale.

Default value: en_US

The strength defines the comparison rules. The assignment of strengths to language features is locale dependant.
Four strengths are provided:

• PRIMARY
  only primary differences, for example "a" vs "b".
• SECONDARY
  locale-sensitive differences and above, for example "a" vs "ä".
• TERTIARY
  case sensitive differences and above, for example "a" vs "A".
• IDENTICAL
  all differences are considered significant during comparison.

For more information please see java.text.Collator.
Note: To use this option please check that your database supports case sensitive comparison and applies same locale.

Default value: PRIMARY