Compatibility Views | Advanced SQL Engine 17.10 - Compatibility Views - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Release Definition

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xvd1618799188927.ditamap
dita:ditavalPath
xvd1618799188927.ditaval
dita:id
B035-1725
lifecycle
previous
Product Category
Teradata Vantage

Compatibility views convert the native variable-length Unicode object names to 30 bytes of either Latin or Kanji1.This can cause either loss of information by truncation or inability to convert object names longer than 30 characters into Latin or Kanji1. Characters that cannot be converted are replaced by the substitution character, which is 0x1A for both Latin and Kanji1.

When object names are returned to the user, they are converted to the session character set. If the characters in the object name cannot be converted to the session character set or exceed the export width for the character data, the conversion can produce loss of information. Teradata recommends using Unicode views. For more information, see Teradata Vantageā„¢ - Data Dictionary, B035-1092, available at https://docs.teradata.com/.