Specify Source and Target Character Sets | Teradata Data Mover - About Specifying Source and Target Session Character Sets in a Job - 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

Data Mover automatically chooses a default source and target session character set when creating or executing a job. The default session character set is ASCII, UTF8, or UTF16. The session character set chosen for each job is determined by the versions of the source and target systems and the characteristics of the objects being copied. Choosing a different source and target session character set is useful when the object names or data were originally created using a different session character set than any of the default values. For example, if data was originally inserted into the source table using KANJISJIS_0S as the session character set, you would want to specify KANJISJIS_0S as the source and target session character set when copying the data using Data Mover.

Data Mover supports specifying all of the session character sets supported by the Teradata JDBC driver as follows:

  • ASCII
  • UTF8
  • UTF16
  • KANJIEUC_0U
  • KANJISJIS_0S
  • HANGULKSC5601_2R4
  • LATIN1_0A
  • LATIN1252_0A
  • LATIN9_0A
  • SCHGB2312_1T0
  • TCHBIG5_1R0

Data Mover does not support user defined session character sets or the 12 Vantage session character sets that the JDBC driver currently does not support. This is due to the fact that Data Mover cannot execute any queries on the source or target system if using any of these character sets.

The session character sets can be specified for both the source and target system in the job definition as follows:

<source_tdpid>hummingbird</source_tdpid>
<source_user>dmguest</source_user>
<source_password>dmguest</source_password>
<source_session_charset>KANJIEUC_0U</source_session_charset>
<target_tdpid>apollo</target_tdpid>
<target_user>dmguest</target_user>
<target_password>dmguest</target_password>
<target_session_charset>KANJIEUC_0U</target_session_charset>