Neoview SQL Reference Manual (R2.2)

UCASE Function
• “Considerations for UCASE”
• “Examples of UCASE”
The UCASE function upshifts characters. 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 or UPSHIFT
function.
For 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)).
A lowercase character is a character that has the “alphabetic” property in Unicode Standard 2
and whose Unicode name includes lower. An upper case 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.
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 208).
Considerations for UCASE
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
1FFA1F7C1E881E8904E804E903E203E3018B018C004B006B
1FFB1F7D1E8A1E8B04EA04EB03E403E501910192004C006C
UCASE Function 419