VARGRAPHIC Function Examples | VantageCloud Lake - VARGRAPHIC Function Examples

The following table shows examples of converting strings that use the UNICODE and LATIN server character sets to GRAPHIC data.

Function	Result
VARGRAPHIC('92 abcΔ ')	'92 abc Δ '
VARGRAPHIC('abc')	'abc '

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 .)

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 .)

VARGRAPHIC Function Examples | VantageCloud Lake - VARGRAPHIC Function Examples - Teradata Vantage