Neoview Character Sets Administrator's Guide (R2.4, R2.5)

Table 3-4 Behaviors of SQL String Functions in the Three Configurations (continued)
Unicode Configuration
Considerations
SJIS Configuration
Considerations
ISO88591
Configuration
ConsiderationsSQL String Function and Description
Every character,
including multibyte
characters, is treated as
one character.
Every character,
including multibyte
characters, is treated
as one character.
Every character,
including multibyte
characters, is treated as
one character.
RPAD: Pads the right side of a string with
the specified string.
No special
considerations
No special
considerations
No special
considerations
RTRIM: Removes trailing spaces from a
character string.
Every character,
including multibyte
characters, is treated as
one character.
The second argument
in the function,
char-set-name
value, can be
ISO88591 or UCS2;
SJIS and UTF8 are not
supported. If you do
not specify the
char-set-name
value, the default is
UCS2.
Every character,
including multibyte
characters, is treated
as one character.
The second argument
in the function,
char-set-name
value, can be
ISO88591 or UCS2;
SJIS and UTF8 are
not supported. If you
do not specify the
char-set-name
value, the default is
ISO88591 (containing
SJIS data).
Every character,
including multibyte
characters, is treated as
one character.
The second argument
in the function, the
char-set-name
value, can be
ISO88591 or UCS2;
SJIS and UTF8 are not
supported. If you do
not specify the
char-set-name
value, the default is
ISO88591.
SPACE: Returns a character string
consisting of a specified number of spaces.
When specifying the
length of the substring,
keep in mind that
every character,
including multibyte
characters, is treated as
one character.
When specifying the
length of the
substring, keep in
mind that every
character, including
multibyte characters,
is treated as one
character.
When specifying the
length of the substring,
keep in mind that
every character,
including multibyte
characters, is treated as
one character.
SUBSTRING: Extracts a substring out of a
given character expression.
No special
considerations
No special
considerations
No special
considerations
SUBSTR: Same as SUBSTRING.
30 Using SQL Language Elements to Define and Manage Database Encoding