Multi-Byte Object Support | Teradata Data Mover - Multi-Byte Object Support - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem
In general, Data Mover supports copying tables that contain any kind of character data. Therefore, tables with CHARACTER SET UNICODE, CHARACTER SET LATIN, CHARACTER SET KANJISJIS, or CHARACTER SET KANJI1 columns will be copied correctly in most cases. However, the following scenarios could cause database errors when copying data:
  • Different export width on the source and target systems
  • Copying KANJI1 data to or from a Vantage system
  • Copying a Character PPI table with Teradata PT API or JDBC when the default collation of the target user does not match the PPI collation of the source table
  • Copying a table that contains a mixture of CHARACTER SET UNICODE, CHARACTER SET LATIN, CHARACTER SET KANJISJIS, or CHARACTER SET KANJI1 columns

If an "untranslatable character" error occurs when copying data, the source and target session character sets may need different values in the Data Mover job.

Multi-byte object names are only supported when they are specified in UTF-8.