17.10 - About Export Widths - 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)

The number of characters or bytes the Teradata Database exports can exceed or be less than the number of characters or bytes the client application expects to receive unless the export width is set properly.

The export width defines how the system reserves space for each character field in result set rows returned to Teradata clients. The global export width is set by default, but you can change the setting. In addition, users with the required privileges can override the global setting with a session-level export width setting.

64000 bytes is the maximum possible for an exported character string.