17.00 - Maximum Mode - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

Provide the maximum default export width for a character data type and client form-of-use. The expected width multiplier for this case is 2 with an adjustment of 1.

Maximum mode is designed to handle cases where there can be multiple Shift Out and Shift In characters in the same string for a mainframe client. Because determining a true maximum is a complex computation, Vantage simplifies the calculation to just multiply n *3 to determine the number of bytes exported based on the number of Unicode characters.

This works except for the case where the length of the character string is 1. The maximum number it could take is two bytes for a double byte character plus 1 byte each for the Shift Out and Shift In characters (assuming the client is a mainframe), making four bytes. Vantage adds 1 byte to handle this case.