SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-39
Examples—Collation Definitions
positions in the collating sequence. The letter b collates the same as itself,
although the weight symbol is omitted.
LC_COLLATE
order_start forward
A A
B B
... ...
Z Z
a A
b
order_end
END LC_COLLATE

This example also demonstrates the use of ellipsis and weight in an order list of
an LC_COLLATE section, but uses them differently than the previous example.
The first ellipsis specifies that all the characters between the letters a and z have
unique weights equal to the relative order of the characters. The second ellipsis
specifies that all the characters between the letters A and E have the same weight
as the letter a. The third ellipsis specifies that all the characters between the letters
E and N have unique weights equal to the relative order of the characters.
LC_COLLATE
order_start forward
<a>
...
<z>
<A>
... <a>
<E> <e>
... ...
<N> <n>
order_end
END LC_COLLATE

This sample collation definition includes an LC_COLLATE clause, an LC_CTYPE
clause, and an LC_TDMCODESET clause: