17.05 - Compatibility Mode - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

Enables Unicode column data to be processed by applications written to process Latin or Kanji1 character data. The expected export width multiplier for this case is 1 with an adjustment of 0.

Assume that you have changed your Kanji1(n ) columns to Unicode(n ) columns, so you always want your exported character strings to have n bytes. Because of this, Compatibility mode does not add any bytes for Shift Out/Shift In support for mainframe systems.

Your Kanji1 column was already designed to store Shift Out/Shift In characters, and the corresponding new Unicode definition enables data exported to a mainframe client to have enough room to include those Shift Out and Shift In characters.