NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-28
Comment and Escape Characters in Collation
Definitions
section, and the LC_TDMCODESET section), and ending with examples and special
considerations.
Remember that keywords shown in uppercase must be entered in uppercase, and
keywords shown in lowercase must be entered in lowercase. Also note that angle
brackets appear in several parts of the collation definition language as an element of the
language itself, not only to represent variable items you must supply, as they are
commonly used elsewhere in this documentation.
Comment and Escape Characters in Collation Definitions
The default comment character is the number sign (#).
The default escape character is the backslash (\).
Use the comment character to include comments in a collation definition. All characters
between the comment character and the end of a physical line are treated as a comment,
including the escape character.
You use the escape character to continue a clause over more than one physical line. If
you specify the escape character as the last character in a physical line, the following
line is treated as a continuation of the line that ended with the escape character. You also
use the escape character to indicate the beginning of an octal, decimal, or hexadecimal
code that represents a character within the collation, as explained later, in the description
of the LC_COLLATE section.
To change the comment character or escape character, specify a new character in angle
brackets in a comment_char or escape_char clause at the beginning of the collation
definition. For example, the following statement changes the comment character to $
and the escape character to @:
comment_char <$>
escape_char <@>
The comment_char and escape_char clauses can appear in any order, but each clause, if
used, must appear before the main sections of the collation definition. Each can appear
only once in the entire collation definition and must be on its own physical line.
You cannot specify the backslash (\) or the escape character as the comment character.
You cannot specify the number sign (#) or the comment character as the escape
character.
The escape character, the comment character, and the following punctuation characters
have special meanings in the collation definition language:
, Comma
; Semi-colon
" Quotation mark
. Period
( Left parenthesis
) Right parenthesis
< Left angle bracket
> Right angle bracket