Character Data | Database Dictionary | VantageCloud Lake - Character Data - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Character data in the Data Dictionary affects the following kinds of view columns:

View Column Effect
Object Name To make the Data Dictionary field definitions consistent across all Teradata platforms, the following attributes apply to each object name:
  • All object name columns are VARCHAR(128) CHARACTER SET UNICODE.
  • The default format for the object names is defined as X(128).
Text Strings In the Data Dictionary, there are object names, SQL Text, and other fields (for example, Title) that are Unicode.
Other Character Data The server character set of non-object name character fields in the Data Dictionary is Latin. These fields (for example, CHAR(1) or CHAR(2)) have a fixed set of values (for example, Y, N, A, CV, and so on) and contain characters from U+0020 to U+007F (for example, A is U+0041).

See Client Character Set Compatibility with Server Character Sets.