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

Table 3-1 Summary of SQL Language Rules by Neoview Character Set Configuration (continued)
Unicode ConfigurationSJIS ConfigurationISO88591 ConfigurationSQL Language Rule
EMS Event Messages
Uses UTF8 encoding.Uses UTF8 encoding.EMS event messages use
client locale character
encoding and might not be
readable from Neoview DB
Admin.
EMS event messages
from the Neoview
platform are normally
sent in UTF8 encoding.
Behavior of SQL Functions
Table 3-2 (page 26) describes the behavior of the SQL functions that operate on character data
for each of the three Neoview character set configurations.
Table 3-2 Behavior of SQL Functions
Unicode ConfigurationSJIS ConfigurationISO88591 ConfigurationSQL Function
Returns ASCII characters in
UCS2 encoding
Returns ASCII characters in
ISO8859-1 encoding
Returns ASCII characters in
ISO8859-1 encoding
CONVERTTOHEX
Returns user role name in UCS2
encoding.
Returns user role name in
ISO8859-1 encoding
Returns user role name in
ISO8859-1 encoding
CURRENT_USER
Returns the datetime value in
UCS2 encoding
Returns the datetime value in
ISO8859-1 encoding
Returns the datetime value in
ISO8859-1 encoding
DATEFORMAT
Returns the name of the day
from a date or timestamp
expression in UCS2 encoding
Returns the name of the day
from a date or timestamp
expression in ISO8859-1
encoding
Returns the name of the day
from a date or timestamp
expression in ISO8859-1
encoding
DAYNAME
Returns the name of the month
from a date or timestamp
expression in UCS2 encoding
Returns the name of the
month from a date or
timestamp expression in
ISO8859-1 encoding
Returns the name of the month
from a date or timestamp
expression in ISO8859-1
encoding
MONTHNAME
Returns user role name in UCS2
encoding
Returns user role name in
ISO88591 encoding
Returns user role name in
ISO88591 encoding
SESSION_USER
Returns the current user role
name or the role assigned to a
number in UCS2 encoding
Returns the current user role
name or the role assigned to a
number in ISO8859-1 encoding
Returns the current user role
name or the role assigned to a
number in ISO8859-1 encoding
USER
Behavior of SQL String Functions
Table 3-3 (page 26) describes the behavior of SQL string functions that use the character sets for
the default columns in the ISO88591, SJIS, and Unicode configurations (the ISO8859-1 character
set for the ISO88591 and SJIS configurations and the UCS2 characters for the Unicode
configuration). SQL string function values can be provided to table columns in the form of a
literal or a parameter.
Table 3-3 Behavior of SQL String Functions
Unicode ConfigurationSJIS ConfigurationISO88591 Configuration
SQL String
Function
An error is generated because an
ISO8859-1 character is expected.
ASCII value of the first byte.ASCII value of the first byte.ASCII
Returns the UCS2 character of a
number in the range 0 through
65533.
Returns the ISO8859-1
character of a number in the
range 0 through 255.
Returns the ISO8859-1 character
of a number in the range 0
through 255.
CHAR
26 Using SQL Language Elements to Define and Manage Database Encoding