Answer: Please use the followings (in the order of priority)
- CHARSET’ option in first line in param file
- GLOBAL ‘CHARSET’ parameter
Answer: In the defsfile, change CHARSET xxx
3. How does GoldenGate replicat determine Source DB Charset?
Answer: The GoldenGate replicat determines the source DB charset with the followings (in order of priority)
- DB Charset info in trail header
- DB Charset info in definition file
Answer: You can use the SOURCECHARSET OVERRIDE parameter.
5. How does GoldenGate replicat determine Target DB Charset?
Answer: GoldenGate just does a query after connecting to target DB.
6. How GoldenGate determines Table/Column Charset?
Answer: Inherited from DB charset by default
7. How can I override Table Charset?
Answer: You can override in defgen file or in the replicat parameter file shown as follows:
- Defgen param file: TABLE T1, CHARSET xxx
- Replicat param file: MAP srcdb.t1, TARGET tgtdb.t1, CHARSET xxx
8. How can I override Column-level Charset?
Answer: You can over write in defgen file or in the replicat parameter file shown as follows:
- Defgen param file: TABLE T1, COLCHARSET (xxx, col1, col2)
- Replicat param file (12.1.2.1+ only) : MAP srcdb.t1, TARGET tgtdb.t1, COLCHARSET (xxx, col1, col2)
9. What if replicat abend with charset conversion error (usually complaining not a valid code point in target DB charset)?
Answer: Please add the following parameter in the repliat first: REPLACEBADCHAR ESCAPE. If the character is confirm correct, then use CHARMAP to perform the mapping.
Other FAQs