16.20 - Example - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

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