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

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
tpf1598412463935.ditamap
dita:ditavalPath
tpf1598412463935.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantage™

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.