SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-32
The LC_COLLATE Section of a Collation Definition
The LC_COLLATE Section of a Collation Definition
The LC_COLLATE section defines multicharacter elements of the collation and
specifies the order of character and multicharacter elements within the collation. The
LC_COLLATE section is the only required section in a collation definition.
The LC_COLLATE section can appear only once in a collation definition. Each of the
six types of lines that make up the section must begin on a new physical line. Most
types of lines can appear only once in the section. If a specific type of line can appear
more than once, that is noted in its description.
LC_COLLATE
starts the LC_COLLATE section.
collating-element <new-element> from "char char"
defines a new multicharacter element for the collation. The angle brackets are a
required part of the syntax for new-element, but not for the remaining portion of
the clause. For example, either of these clauses defines a new collating element
<CH> from the combination of the characters C and H:
collating-element <CH> from "CH"
collating-element <CH> from "\d67\d72"
The first char in the pair cannot be the space character. In addition, if the first
char in the pair is in octal, hexadecimal, or decimal format and the second char
represents a digit in the corresponding base (octal, hexadecimal, or decimal), you
cannot use simple format for the second char. (For information of each format,
see the description of char on page C-33.)
You can specify multiple collating-element clauses (subject to the general limits
described under Considerations sub-section on page C-38
), but each one must
appear on a separate line and all such clauses must precede the order_start
clause.
LC_COLLATE
[ collating-element <new-element> from "char char" ]
order_start [ forward ]
element [ weight ]
order_end
END LC_COLLATE