NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-79
Considerations—String Literals
The character set is one of the single-byte character sets ISO 8859/1 through ISO
8859/9 or one of the double-byte character sets Kanji or KS C5601. (See Character
Sets on page C-16 for more information about character sets.)
_UNKNOWN
specifies that data in the string literal belongs to an unknown character set.
Specifying UNKNOWN is equivalent to omitting the character set specification.
NonStop SQL/MP handles the data as if it were 8-bit data.
N
associates the system default multibyte character set with the string literal. (Kanji is
the standard system default multibyte character set, but the default can be different
at your site. See Multibyte Character Sets on page M-25 for more information.)
string
is a series of single-byte or double-byte characters.
Considerations—String Literals
•
Specifying quotation marks within string literals
As indicated in the syntax diagram, you must enclose string literals in either single
(') or double (") quotation marks, although the value of the string literal does not
include the quotation marks. To specify the delimiter character within the literal, use
two consecutive quotation marks.
•
String literal length
A string literal can be as long as a character column. See Limits
on page L-5 for
limits on data length.
•
Long string literals in SQLCI
To specify a long string literal in SQLCI, separate the literal into several smaller
string literals and use line-continuation characters (&) to connect them.
In host programs, rules for breaking string literals across lines depend on the
language being used.
•
Case in string comparisons
In string comparisons, lowercase letters are not equivalent to the corresponding
uppercase letters.
•
Double-byte character sets
Strings associated with double-byte character sets must contain an even number of
bytes. An error occurs if such a string contains an odd number of bytes.
•
Mixed character sets