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

Table 1-7 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)