UTF8/UTF16 Considerations |Advanced Database Considerations |TPT Reference - UTF8/UTF16 Considerations - Parallel Transporter

Teradata® Parallel Transporter Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
IntelliFlex
Lake
Enterprise
VMware
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-12-06
dita:mapPath
mjn1691132485167.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
lifecycle
latest
Product Category
Teradata Tools and Utilities

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.