NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-36
Examples—Collation Definitions
The first ellipsis specifies that all of 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 of the characters between the letters A and E have the same weight
as the letter a. The third ellipsis specifies that all of 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
•
The following sample collation definition includes an LC_COLLATE clause, an
LC_CTYPE clause, and an LC_TDMCODESET clause:
LC_COLLATE
# This case insensitive collating sequence sorts most of
# the accented forms of a, e, i, o, and u equal to the
# unaccented form.
# Upshift for a, e, i, o, u -grave -acute -circumflex
# is A, E, I, O, U. Upshift for e-umlaut is E. Upshift
# for i-umlaut is I, and upshift for y-acute is Y.
# The actual collating sequence starts here:
order_start forward
\d032 \d032 # 32 is the space character
\d160 \d032 # NBSP (non breaking space)
<0> <0>
... ...
<9> <9>
<A> <A>
... ...
<Z> <Z>
<a> <A>
... ...
<z> <Z>
\d192 <A> # 192 - 195 and 224 - 227
... <A> # are forms of "A" and "a"
\d195 <A>
\d224 <A>
... <A>
\d227 <A>
\d199 <C> # 199 = C-cedilla
\d231 <C> # 231 = c-cedilla
\d208 <D> # 208 = Eth
\d240 <D> # 240 = eth