17.10 - Casting Character String Attributes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
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.