1.2.3 Notes on using character data, national character data, and mixed character data

The following table provides notes on the use of character data, national character data, and mixed character data.

Table 1-7 Notes on use of character data, national character data and mixed character data

ItemData type
CHAR, NCHAR or MCHARVARCHAR, NVARCHAR or MVARCHAR
Defined length
1-255 (1-127)256-30000 (128-15000)1-255 (1-127)256-32000 (128-16000)
Index definitionYY#YY#
SortingYYYY
GroupingYYYY
Set functionsYYYY
Search conditionsYYYY
Data insertion/updatingYYYY
Exclusion of duplicatesYYYY
Set operationsYYYY
Y: Can be used.
( ): In the Defined length row, the values in parentheses are for national character data.
#: The total length of a column comprising an index must satisfy the following formula:
Total column length [Figure]
MIN((page-size-of-index-storage-RDAREA[Figure] 2) - 1242, 4036)