Neoview Character Sets Administrator's Guide (R2.3)

Table 3-3 Behavior of SQL String Functions (continued)
Unicode ConfigurationSJIS ConfigurationISO88591 Configuration
SQL String
Function
Returns the number of UCS2
characters.
Returns the number of bytes.Returns the number of
ISO88591 characters.
CHAR_LENGTH
Returns the code point for the
first bytes in the expression.
Returns the code point for the
first byte in the expression.
Returns the code point for the
first byte in the expression.
CODE_VALUE
Returns the concatenation of the
two character expressions. Both
expressions must be ISO8859-1
character expressions or both
must be UCS2 character
expressions.
Returns the concatenation of
the two character expressions.
Both expressions must be
ISO8859-1 character
expressions or both must be
UCS2 character expressions.
Returns the concatenation of
the two character expressions.
Both expressions must be
ISO8859-1 character expressions
or both must be UCS2 character
expressions.
CONCAT
Returns a UCS2 character string
where the specified number of
characters have been deleted,
beginning at the specified UCS2
character start position. The
other character expression in
UCS2 characters is then inserted
in that start position.
Returns an ISO8859-1
character string where the
specified number of bytes
have been deleted, beginning
at the specified start position
(in bytes). The other character
expression in ISO8859-1
characters is then inserted in
that start position (in bytes).
NOTE: This operation might
truncate multibyte characters
at the start position.
Returns an ISO8859-1 character
string where the specified
number of characters have been
deleted, beginning at the
specified start position. The
other character expression in
ISO8859-1 characters is then
inserted in that start position.
INSERT
Downshifts the UCS2 characters
in a UCS2 expression. For
information about UCS2
characters that the LCASE
function is aware of, see the
Neoview SQL Reference Manual.
Downshifts the ISO8859-1
characters in an ISO8859-1
expression.
NOTE: If the expression
contains SJIS characters, the
result may contain invalid SJIS
characters. The LCASE
function works on one byte at
a time, not on one character at
a time.
Downshifts the ISO8859-1
characters in an ISO8859-1
expression.
LCASE
Returns the leftmost UCS2
characters from the UCS2
character expression.
Returns the leftmost bytes
from the character expression.
NOTE: This operation might
truncate a multibyte character.
Returns the leftmost ISO88591
characters from the ISO8859-1
expression.
LEFT
Returns the character position of
one UCS2 character string within
another UCS2 string.
Returns the byte position of
one character string within
another character string.
Returns the character position
of one ISO8859-1 character
string within another ISO8859-1
string.
LOCATE
Same as LCASESame as LCASESame as LCASELOWER
Pads the left side of a UCS2
string with a specified UCS2
string.
Pads the left side of an
character string with a
specified string up to the
specified length in bytes.
NOTE: This operation might
truncate a multibyte character.
Pads the left side of an
ISO8859-1 string with a
specified ISO8859-1 string.
LPAD
Removes leading UCS2 space
characters from the left of the
string.
Removes leading ISO8859-1
space characters from the left
of the string.
Removes leading ISO8859-1
space characters from the left
of the string.
LTRIM
Behavior of SQL String Functions 27