Sort Collating Sequence - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

You can select a specific collating sequence when sorting the data using the Sort Utility. If omitted, the default collating sequence defined by the operating system is used. Select one of the following options when specifying the Sort Order:   

Option Description

ASCII

The default collating sequence for character data. The ASCII sequence orders numbers (0 to 9) first, then uppercase letters (A to Z), and then lowercase letters (a to z).

EBCDIC

Generates an output file that is ordered in EBCDIC sequence. The EBCDIC sequence orders lowercase letters (a to z) first, then uppercase letters (A to Z), and then numbers (0 to 9).

FOLDED_ASCII

Specifies that all lowercase letters be given the collating value of their uppercase equivalents. For ASCII, EBCDIC, and user-defined sequences, the lowercase letters are a to z.

FOLDED_EBCDIC

Specifies that all lowercase letters be given the collating value of their uppercase equivalents. For ASCII, EBCDIC, and user-defined sequences, the lowercase letters are a to z.

MULTI_NATIONAL

The multinational collating sequence collates characters according to the DEC Multinational character set. In the MULTINATIONAL character sequence, characters are ordered according to the following rules:

  • All diacritical forms of a character are given the collating value of the character (A', A", A` collate as A).
  • Lowercase characters are given the collating value of their uppercase equivalents (a collates as A, a" collates as A").
  • If two strings compare as equal, tie-breaking is performed. The strings are compared to detect differences due to diacritical marks, ignored characters, or characters that collate as equal although they are actually different. If strings still compare as equal, another comparison is done based on the numeric codes of the characters. In this final comparison, lowercase characters are ordered before uppercase.