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)

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.