SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-34
The LC_COLLATE Section of a Collation Definition
and this element in the collation definition. Neither the preceding element nor
this element can be an ellipsis.
If element is UNDEFINED, it specifies all characters in the character set not
previously included in the ordered list (either directly or with an ellipsis). You can
use UNDEFINED only as the last element before order_end. The only weight
allowed with UNDEFINED is IGNORE.
weight
is a char or element that appears earlier in the ordered list and that specifies a
relative position in the collating sequence as a weight for the corresponding
element. weight can also be an ellipsis (...) or the keyword IGNORE.
If you omit weight for a collation element, that element represents itself in the
collation sequence.
If weight is an ellipsis, element must also be an ellipsis and each character
specified by the ellipsis in the element column has the unique weight for that
character.
If weight is IGNORE, SQL handles the corresponding element as if it does not
exist during a comparison between two strings. For example, specifying this three
element [weight] pairs:
<a>
<b> IGNORE
<c>
causes SQL to handle the strings “aacba” and “aaca” as equal in a comparison
that uses the collation.
Note that each character in a given character set (ISO88591, for example), has a
unique value as a physical weight. The values of the physical and logical weights
of a character might differ when a user specifies a weight in a collating sequence.
order_end
ends the ordered list of elements in the collation.
END LC_COLLATE
ends the LC_COLLATE section.