1. Oracle GoldenGate Classic Architecture Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. Teradata
  5. Understanding What's Supported for Teradata
  6. Supported Teradata Data Types
  7. Conditions and Limitations of Support for Multi-byte Character Data

Conditions and Limitations of Support for Multi-byte Character Data

Conditions and limitations of support for multi-byte character data are as follows:

  • Install Oracle GoldenGate on a Windows or Linux replication server.

  • Use the Teradata ODBC driver version 12.0.0.x or later.

  • Do not use filtering, mapping, and transformation for multi-byte data types.

  • A CHAR or VARCHAR column cannot contain more than 32k-1 bytes. If using UTF-16, these columns cannot contain more than 16k-2 characters.

  • Set the ODBC driver to the UTF-16 character set in the initialization file.

  • When creating Replicat groups, use the NODBCHECKPOINT option with the ADD REPLICAT command. The Replicat database checkpointing feature does not support an ODBC driver that is set to the UTF-16 character set. Checkpoints will be maintained in the checkpoint file on disk.