SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-31
Comment and Escape Characters in Collation
Definitions
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, this 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 these punctuation characters have
special meanings in the collation definition language:
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.
,Comma
; Semi-colon
" Quotation mark
.Period
( Left parenthesis
) Right parenthesis
< Left angle bracket
> Right angle bracket