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 bytes in
a UCS2 string.
Returns the number of bytes
in the character string.
Returns the number of bytes in
an ISO8859-1 string.
OCTET_LENGTH
Same as LOCATESame as LOCATESame as LOCATEPOSITION
Returns a character string made
by the repetition of the provided
character string by the number
of times specified.
Returns a character string
made by the repetition of the
provided character string by
the number of times specified.
Returns a character string made
by the repetition of the
provided character string by the
number of times specified.
REPEAT
Returns a UCS2 character string
where all occurrences of a
specified character string in the
original string (in UCS2) are
replaced with another character
string.
Returns a character string
where all occurrences of a
specified character string in
the original string (in
ISO8859-1) are replaced with
another character string.
Returns a character string
where all occurrences of a
specified character string in the
original string (in ISO8859-1)
are replaced with another
character string.
REPLACE
Returns the rightmost specified
number of UCS2 characters from
a UCS2 character expression.
Returns the rightmost
specified number of bytes
from a character expression.
NOTE: This operation might
truncate a multibyte character
at the start position.
Returns the rightmost specified
number of ISO8859-1 characters
from a character expression.
RIGHT
Pads the right side of a string
with the specified UCS2 string.
Pads the right side of a string
with the specified string.
Pads the right side of a string
with the specified ISO8859-1
string.
RPAD
Removes trailing UCS2 spaces
(0x0020) from a UCS2 character
string.
Removes trailing ISO8859-1
spaces from an ISO8859-1
character string.
Removes trailing ISO8859-1
spaces from an ISO8859-1
character string. .
RTRIM
Returns a character string
consisting of a specified number
of UCS2 spaces.
Returns a character string
consisting of a specified
number of ISO8859-1 spaces.
Returns a character string
consisting of a specified
number of ISO8859-1 spaces.
SPACE
Extracts a substring out of a
given character string using a
specified starting character
position and a specified length
in characters.
Extracts a substring out of a
given character string using a
specified byte position and a
specified length in bytes.
NOTE: This operation might
truncate a multibyte character
at the start of the result string
and/or at the end of the result
string.
Extracts a substring out of a
given character string using a
specified starting character
position and a specified length
in characters.
SUBSTRING
Same as SUBSTRINGSame as SUBSTRINGSame as SUBSTRINGSUBSTR
Translates a character string
from a source character set to a
target character set (from
ISO8859-1 to UCS2 or from UCS2
to ISO8859-1).
Translates a character string
from a source character set to
a target character set (from
ISO8859-1 to UCS2 or from
UCS2 to ISO8859-1).
Translates a character string
from a source character set to a
target character set (from
ISO8859-1 to UCS2 or from
UCS2 to ISO8859-1).
TRANSLATE
Removes leading and trailing
UCS2 space (0x0020) characters
from a UCS2 character string.
Removes leading and trailing
ISO8859-1 space characters
from an character string.
Removes leading and trailing
ISO8859-1 space characters
from an character string.
TRIM
28 Using SQL Language Elements to Define and Manage Database Encoding