17.00 - Compatibility Mode - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

Enable 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.