Character-type columns (CHAR, VARCHAR, CLOB, JSON) in database tables are defined in terms of characters. Client applications, such as Teradata Parallel Transporter, process data for those columns in terms of bytes.
Careful consideration should be taken when attempting to load data into character-type columns when the sizes of those columns approach more than half of the maximum allowed by the database.
For columns defined in the database as CHAR(32000) CHARACTER SET UNICODE and/or VARCHAR(32000) CHARACTER SET UNICODE:
- For Client Session Character Sets of UTF8:
- The maximum size in a TPT script schema is 32000.
- For Client Session Character Sets of UTF16:
- The maximum size in a TPT script schema is 64000.
For columns defined in the database as CLOB(1048544000) CHARACTER SET UNICODE and/or JSON(1048544000) CHARACTER SET UNICODE:
- For Client Session Character Sets of UTF8:
- The maximum size in a TPT script schema is 1048544000.
- For Client Session Character Sets of UTF16:
- The maximum size in a TPT script schema is 2097088000.
For the Stream Operator, though, since DML statements are executed through macros, there are additional limitations imposed by the Teradata Database, as follows:
For columns defined in the database as CHAR(32000) CHARACTER SET UNICODE and/or VARCHAR(32000) CHARACTER SET UNICODE:
- For Client Session Character Sets of UTF8 and UTF16:
- The maximum size in a TPT script schema is 32000.
For columns defined in the database as CLOB(1048544000) CHARACTER SET UNICODE and/or JSON(1048544000) CHARACTER SET UNICODE:
- For Client Session Character Sets of UTF8 and UTF16:
- The maximum size in a TPT script schema is 1048544000.