16.20 - Casting Character String Attributes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

When the source UDT or string being manipulated by a cast operation is a VARCHAR or CHARACTER type, the server character set that is associated with that source type must be one of the following:

  • The server character set that was declared for that source type within the CREATE TYPE declaration that created the distinct type UDT.
  • The character set that was in effect at the time that the CREATE TYPE declaration was executed.