17.10 - Effects of Shift Out and Shift In Characters on Export Widths - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

Shift Out and Shift In are control characters used to switch to a different character set and back for data exported to mainframes. Workstation-attached systems do not use the Shift Out and Shift In characters.

  • Shift Out shifts to an alternative character encoding, which for Teradata is always a double-byte encoding.
  • Shift In returns to the normal character encoding, which for Teradata is always a single-byte encoding.

Vantage assumes that all character strings (with the exception of CHARACTER SET GRAPHIC columns outside of Field mode) are in single-byte mode initially, and must be returned to single-byte mode before the string ends.

The following session character sets are affected significantly by Shift Out/Shift In considerations for export widths.

  • KatakanaEBCDIC
  • Any session character set that ends in the string '_0I'
  • Any site-defined session character set with STATEMACHINE SOSI0E0F.

For more information about these character sets in the context of session export widths, see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.