About Export Widths - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.