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

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_ROLE
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 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
26 Using SQL Language Elements to Define and Manage Database Encoding