SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-40
Examples—Collation Definitions
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
\d200 <E> # 200 - 203 and 232 - 235
... <E> # are forms of "E" and "e"
\d203 <E>
\d232 <E>
... <E>
\d235 <E>
\d204 <I> # 204 - 207 and 236 - 239
... <I> # are forms of "I" and "i"
\d207 <I>
\d236 <I>
... <I>
\d239 <I>
\d209 <N> # 209 = N-tilde
\d241 <N> # 241 = n-tilde