15.10 - Maximum Mode - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
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, Teradata Database 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. Teradata Database adds 1 byte to handle this case.