Character Data Type Assignment Rules | Data Types & Literals | Teradata Vantage - 17.10 - Character Data Type Assignment Rules - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

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.