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.