Neoview SQL Reference Manual (R2.4)

UCASE Function
• “Considerations for UCASE”
• “Examples of UCASE”
The UCASE function upshifts alphanumeric characters. For non-alphanumeric characters, UCASE
returns the same character. UCASE can appear anywhere in a query where a value can be used,
such as in a select list, an ON clause, a WHERE clause, a HAVING clause, a LIKE predicate, an
expression, or as qualifying a new value in an UPDATE or INSERT statement. The result returned
by the UCASE function is equal to the result returned by the “UPPER Function” (page 472) or
“UPSHIFT Function” (page 473).
UCASE returns a string of fixed-length or variable-length character data, depending on the data
type of the input string.
UCASE is a Neoview SQL extension.
UCASE (character-expression)
character-expression
is an SQL character value expression that specifies a string of characters to upshift. See
“Character Value Expressions” (page 240).
Considerations for UCASE
For a UCS2 character expression, the UCASE function upshifts all lowercase or title case characters
to uppercase and returns a character string. If the argument is of type CHAR(n) or VARCHAR(n),
the result is of type VARCHAR(min(3n, 2048)), where the maximum length of VARCHAR is the
minimum of 3n or 2048, whichever is smaller.
A lowercase character is a character that has the “alphabetic” property in Unicode Standard 2
and whose Unicode name includes lower. An uppercase character is a character that has the
“alphabetic” property and whose Unicode name includes upper. A title case character is a
character that has the Unicode “alphabetic” property and whose Unicode name includes title.
Table 6-2 lists all one-to-one mappings for the UCS2 character set. In addition, it is possible for
the result string to be longer than that of the source because some of the title case characters can
be mapped to multiple characters.
Table 6-3 lists UCS2 characters with two-character uppercase mapping.
Table 6-4 lists UCS2 characters with three-character uppercase mapping.
Characters not listed in these tables use themselves as their uppercase mappings.
Table 6-2 One-to-One UCS2 Mappings
U(x)xU(x)xU(x)xU(x)xU(x)xU (x)x
1FC81F721E741E7504D404D503A903C90172017300410061
1FC91F731E761E7704D604D703AA03CA0174017500420062
1FCA1F741E781E7904D804D903AB03CB0176017700430063
1FCB1F751E7A1E7B04DA04DB038C03CC0179017A00440064
1FDA1F761E7C1E7D04DC04DD038E03CD017B017C00450065
1FDB1F771E7E1E7F04DE04DF038F03CE017D017E00460066
1FF81F781E801E8104E004E1039203D00053017F00470067
1FF91F791E821E8304E204E3039803D10182018300480068
1FEA1F7A1E841E8504E404E503A603D50184018500490069
1FEB1F7B1E861E8704E604E703A003D601870188004A006A
464 SQL Functions and Expressions