The
NCLOB function returns a NCLOB representation of any type of national
character string.
>>-NCLOB--(--national-character-expression--+------------+--)--><
'-,--integer-'
The schema is SYSIBM.
The NCLOB function can be
specified only in a Unicode database (SQLSTATE 560AA).
The NCLOB scalar function is a synonym for
a scalar cast function with result string units as specified in the
following table.
Table 1. NCLOB scalar function synonymsNCLOB_MAPPING value |
Synonym function |
Result string units |
CHAR_CU32 |
CLOB |
CODEUNITS32 |
GRAPHIC_CU32 |
DCLOB |
CODEUNITS32 |
GRAPHIC_CU16 |
DCLOB1 |
CODEUNITS16 |
- When the first argument has string units CODEUNITS32 and the
second argument is not specified, the length attribute of the result
is different from the DCLOB function because the string units of the
result is CODEUNITS16. In this case, the length attribute of the result
is 2 times the length attribute of the result that is otherwise determined
by the DCLOB function.
|