collating sequence

For a list of the available collating sequence labels, see Understanding collations.

The sort command sorts the input using the collating sequence for the locale (LC_COLLATE) of the system.

It applies to character data types and those data sources for which the COLLATING_SEQUENCE server option is not set to 'Y. '

In this case, you can set the server option COLLATING_SEQUENCE to ? Y? for sources with ASCII encoding and identity sorting order.

Create the TEST database with same codepage, territory and collating sequence as production.

This collator ensures all characters, supplementary and non-supplementary, have the same binary collating sequence as UTF-8.

While choosing collating sequence, you should also consider the performance implication.

For character columns, MIN finds the lowest value in the collating sequence.

The join is performed on matching characters according to the locale's collating sequence.

The second example in Listing 14 shows sorting the first field numerically and the second by collating sequence (alphabetically).

Describes how to create a custom collating sequence for a code page.

For character columns, MAX finds the highest value in the collating sequence.

Our sort was by collating sequence, so uniq gives us the "10 apple" line instead of the "1 apple" .

You get a correct sort order with the collating sequence UCA400_NO in V8. 2.

For example, the collating sequence in ASCII is: space, numeric values, upper case characters, lower case characters.

On the other hand, the collating sequence in EBCDIC is: space, lower case characters, upper case characters, and numeric values.

Some attributes, such as COLLATING_SEQUENCE, can affect which operations can be pushed down to a data source for evaluation.