16.20 - Maximum Mode - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

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.