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.