Non-GRAPHIC CHARACTER(n) and VARCHAR(n) data types in a USING request modifier are defined in terms of bytes, where the maximum value of n is 64K.
In all other SQL declarations, such as a column definition within a CREATE TABLE statement, non-GRAPHIC CHARACTER(n) and VARCHAR(n) data types are defined as follows:
| This server character set… | Is defined in terms of … | And the maximum value of n is … |
|---|---|---|
| Latin | characters | 64K |
| Unicode | 32K | |
| Kanji1 | bytes | 64K |
| Kanjisjis | 32K |
KANJI1 support is deprecated. KANJI1 is not allowed as a default character set. The system changes the KANJI1 default character set to the UNICODE character set. Creation of new KANJI1 objects is highly restricted. Although many KANJI1 queries and applications may continue to operate, sites using KANJI1 should convert to another character set as soon as possible.
For details on the process of importing character data with a USING request modifier, see Character Data Import Process.