Effects of Shift Out and Shift In Characters on Export Widths - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantageā„¢

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 International Character Set Support, B035-1125.