Character String Assignment and GRAPHIC Columns - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

The following table describes the behavior of character strings assigned to GRAPHIC and non-GRAPHIC columns.

You cannot import non-GRAPHIC data into character columns typed as GRAPHIC, nor can you import GRAPHIC data into character columns that are not typed as GRAPHIC.

IF USING describes a character string for assignment to a column of this type … THEN it must describe the USING string as this type …
GRAPHIC
  • GRAPHIC(n)
  • VARGRAPHIC(n)
  • CHARACTER(n) CHARACTER SET GRAPHIC
  • VARCHAR(n) CHARACTER SET GRAPHIC
LATIN

UNICODE

KANJISJIS

KANJI1

  • CHARACTER(n)
  • VARCHAR(n)