NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-29
The LC_COLLATE Section of a Collation Definition
To specify one of these characters as a character in a collation (rather than as a syntactic
element in the collation definition language), precede the character with the escape
character.
If you redefine the comment or escape character as one of the punctuation characters
just listed, an error occurs if you later use portions of the collation definition language
that include these characters as syntactic elements. As a result, you should normally
select characters other than those listed as the comment character or escape character.
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 the following 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), then
you cannot use simple format for the second char. (See the description of char
later in this entry for details of each format.)
LC_COLLATE
[ collating-element <new-element> from "char char" ]
order_start [ forward ]
element [ weight ]
order_end
END LC_COLLATE