SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-33
The LC_COLLATE Section of a Collation Definition
<new-element>
is a stream of 2 to 30 characters, enclosed in a set of angle brackets, that
represents the new element.
char
is a symbol for a character, from one of the single-byte character sets supported by
NonStop SQL/MP, in one of these forms:
You can use any form shown to define a collation element to NonStop SQL/MP, but
the bracketed form is more portable because it does not depend on a specific
character set, as do the octal, hexadecimal, and decimal forms.
order_start [ forward ]
starts the ordered list of elements in the collation. The ordered list defines the
elements of the collating sequence in ascending order.
“forward” is an optional keyword that specifies that comparison operations for the
weight level proceed from the start to the end of the string, which is always true for
SQL/MP collations. (SQL/MP collation definitions allow you to include the “forward”
option for compatibility with the POSIX/XPG4 standard.)
element [ weight ]
specifies an element in the collating sequence and, optionally, a relative position in
the collating sequence to use as a weight for the element.
You can specify multiple element [weight] clauses, subject only to the limits
defined in the Considerations sub-section of this entry.
element
is a char, a previously defined new-element, an ellipsis (...), or the keyword
UNDEFINED.
If element is an ellipsis, it specifies the ordered series of characters in the
character set between the preceding element specified in the collation definition
Form Example*
Simple (any single printable character) A
Bracketed (a single character in angle brackets) <A>
Octal (an escape character followed by two or more octal digits) \101
Hexadecimal (an escape character followed by “x” and two or more
hexadecimal digits)
\x41
Decimal (an escape character followed by “d” and two or more decimal
digits)
\d65
* Each example specifies uppercase A from the ASCII character set (a subset of the nine character sets
ISO88591 through ISO88599).