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

Table 3-3 Behavior of SQL String Functions (continued)

Unicode ConfigurationSJIS ConfigurationISO88591 Configuration

SQL String

Function

Upshifts UCS2 characters. For

information about the UPSHIFT

function, see the Neoview SQL

Reference Manual.

Upshifts ISO8859-1 characters.

NOTE: If the expression

contains SJIS characters, the

result might contain invalid

SJIS characters. The LCASE

function works on one byte at

a time, not on one character at

a time.

Upshifts ISO8859-1 characters.UCASE

Same as UCASESame as UCASESame as UCASEUPPER

Same as UCASESame as UCASESame as UCASEUPSHIFT

Behavior of SQL String Functions 29