15.00 - Character Data Type Assignment Rules - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)
Last Update
2018-09-24

Character Data Type Assignment Rules

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 SQL Data Manipulation Language.

  • 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 SQL Data Manipulation Language.

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