17.10 - Viewing the Current Export Widths for a Session - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

You can use HELP SESSION to view the current export widths for the session. Based on the rule set shown in About Export Width Rules, and an EXPECTED user default export width, the request returns output similar to the following:

HELP SESSION ;
User Name SPEC2
Account Name DBC
Logon Date 02/08/11
Logon Time 10:58:56
Current DataBase DBC
Collation UTF8
Character Set UTF8
Current DateForm IntegerDate
Session Time Zone -08:00
Default Character Type LATIN
Export Latin 2
Export Unicode 3
Export Unicode Adjust 0
Export KanjiSJIS 1
Export Graphic 3
Export Width Rules 2313
...

where:

Value Description
Export Latin 2 Reports the export width value for each server character data type for the session character set (UTF8).
A 0 value means that character conversion between server and client character sets is not possible, for example, from Graphic (double-byte) to ASCII (single-byte).
Export Unicode 3
Export Unicode Adjust 0
Export KanjiSJIS 1
Export Graphic 3
Export Width Rules 2313 The export width values for converting the session character set to Latin, Unicode, KanjiSJIS, and Graphic.
No export width is reported for the Kanji1 character data type because the export width is always 1.