SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-58
Creating Collation Source Files
\d096 <`>
\d123 <{> # 123 - 126 are symbols encoded in
... ... # sequences
\d126 <~>
\d127 IGNORE
\d196 “<a><e>“ # A-umlaut is sorted as a string of a and e
\d228 “<a><e>“ # a-umlaut is sorted as a string of a and e
\d214 “<o><e>“ # O-umlaut is sorted as a string of o and e
\d246 “<o><e>“ # o-umlaut is sorted as a string of o and e
\d220 “<u><e>“ # U-umlaut is sorted as a string of u and e
\d252 “<u><e>“ # u-umlaut is sorted as a string of u and e
\d223 “<s><s>“ # sharp-s is sorted as a string of s and s
\d163 \d163 # upper half specials and controls
\d215 \d215 # multiply sign
.
.
.
UNDEFINED IGNORE
order_end
END LC_COLLATE
LC_CTYPE
charclass alphas; numerics; specials
alphas <A>;...;<Z>;\
<a>;...;<z>;\
\d192;...;\d214;\d216;...;\d246;\d248;...;\d255
numerics <0>;<1>;\d050;\x33;\
<4>;...;<9>
specials
toupper (<a>,<A>);(<b>,<B>);(<c>,<C>);(<d>,<D>);(<e>,<E>);(<f>,<F>);\
(<g>,<G>);(<h>,<H>);(<i>,<I>);(<j>,<J>);(<k>,<K>);(<l>,<L>);\
(<m>,<M>);(<n>,<N>);(<o>,<O>);(<p>,<P>);(<q>,<Q>);(<r>,<R>);\
(<s>,<S>);(<t>,<T>);(<u>,<U>);(<v>,<V>);(<w>,<W>);(<x>,<X>);\
(<y>,<Y>);(<z>,<Z>);\
(\d224,\d065);(\d225,\d065);\
(\d226,\d065);(\d227,\d195);\
(\d231,\d199);\
(\d236,\d073);(\d237,\d073);\
(\d238,\d073);(\d239,\d073);\
(\d241,\d209);\
(\d242,\d079);(\d243,\d079);\
(\d244,\d079);(\d245,\d213);\
(\d249,\d085);(\d250,\d085);\
(\d251,\d085);\
(\d255,\d089);\
(\d229,\d197);\
(\d248,\d216);\
(\d230,\d198);\
(\d254,\d222);\
(\d228,\d196);\
(\d252,\d220)
END LC_LCTYPE
LC_TDMCODESET
ISO88591 # This specifies the ISO88591 character set.
END LC_TDMCODESET
Example 5-4. Collation Source File (page 3 of 3)