Character Data Type Assignment Rules - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Server Character Sets

LATIN, UNICODE, KANJISJIS, KANJI1, and GRAPHIC server character sets are generally mutually assignable.

Consider an assignment of an expression to a character string column. The assignment may be the result of the SQL UPDATE or INSERT statement, or it may be the result of a Load utility assignment.

The expression is converted to the server character set of the character column.

Exceptions to GRAPHIC Data

The following exceptions apply to GRAPHIC data:

  • When you import GRAPHIC data and assign it to a character column, that column must be defined as GRAPHIC.
  • When you import character data that is not GRAPHIC, you cannot assign it to a column defined as GRAPHIC.

    For more information, see the documentation on the USING row descriptor in Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .

  • You cannot assign non-GRAPHIC data to a GRAPHIC column from BTEQ or load utilities.

    For more information, see the documentation on the USING row descriptor in Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .

  • You cannot assign or export GRAPHIC data from a single byte character set like ASCII or EBCDIC.