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
Both character value
expressions must be
either ISO8859-1
character expressions
or UCS2 character
expressions.
Both character value
expressions must be
either ISO8859-1
character expressions
or UCS2 character
expressions.
Both character value
expressions must be
either ISO8859-1
character expressions
or UCS2 character
expressions.
CONCAT: Returns the concatenation of
two character value expressions as a
character string value.
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.
INSERT: Returns a character string where
a specified number of characters within the
character string has been deleted, beginning
at the specified start position, and where
another character string has been inserted
at the start position.
No special
considerations
No special
considerations
No special
considerations
LCASE: Downshifts alphabetic characters.
For non-alphabetic characters, LCASE
returns the same character.
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.
LEFT: Returns the leftmost specified
number of characters from a character
expression.
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.
LOCATE: Searches for given substring in
a character string. If the substring is found,
Neoview SQL returns the character position
of the substring within the string.
No special
considerations
No special
considerations
No special
considerations
LOWER: Same as LCASE.
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.
LPAD: Pads the left side of a string with
the specified string.
No special
considerations
No special
considerations
No special
considerations
LTRIM: Removes leading spaces from a
character string.
No special
considerations
No special
considerations
No special
considerations
OCTET_LENGTH: Returns the length of a
character string in bytes.
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.
POSITION: Same as LOCATE.
No special
considerations
No special
considerations
No special
considerations
REPEAT: Returns a character string
composed of the evaluation of a character
expression repeated a specified number of
times.
All three character
value expressions must
be comparable types
and must use the same
character set.
All three character
value expressions
must be comparable
types and must use
the same character
set.
All three character
value expressions must
be comparable types
and must use the same
character set.
REPLACE: Returns a character string where
all occurrences of a specified character
string in the original string are replaced
with another character string.
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.
RIGHT: Returns the rightmost specified
number of characters from a character
expression.
Behavior of SQL String Functions 29