Consider the following table definition with two character columns that use the KANJI1 server character set:
CREATE TABLE t1 (c1 VARCHAR(12) CHARACTER SET KANJI1 ,c2 VARCHAR(12) CHARACTER SET KANJI1);
Use the KanjiEBCDIC client character set and insert the following strings:
INSERT t1 ('de
f', 'gH<ABC
>X
');
Convert the strings to GRAPHIC data:
| Function | Result |
|---|---|
| SELECT VARGRAPHIC (c1) FROM t1; | 'def ' |
| SELECT VARGRAPHIC (c2) FROM t1; | 'gH ABCX ' (The single byte Hankaku Katakana X is converted to double byte X .) |