OGG字符转换

czl---

已于 2023-11-28 10:46:37 修改

阅读量824

点赞数

文章标签： ogg oracle

于 2023-01-31 16:33:10 首次发布

本文链接：https://blog.csdn.net/qq_40588579/article/details/128819614

版权

一、ERROR OGG-03533 Conversion from character set CESU-8 of source column BANK_ACCOUNT_NUM_HASH1 to character se

t UTF-8 of target column BANK_ACCOUNT_NUM_HASH1 failed because the source column contains a character '98' at offset 2 that is not a

vailable in the target character set.

报此错的目标端添加参数

SOURCECHARSET OVERRIDE ZHS16GBK

二、OGG-03534

Oracle GoldenGate Delivery for Oracle, rods-hod.prm: Invalid character 'a1' at offset 7 for character set CESU-8 was found while performing character validation of source column ACCT_NUM maps target column ACCT_NUM.

OGG-03521

Invalid character for character set UTF-8

select userenv('language') from dual;

添加参数：

SOURCECHARSET OVERRIDE ZHS16GBK --只能在rep进程里加
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")  --ext，rep进程里都可以加
NOCHARSETCONVERSION
OGG-03517 
加参数：REPLACEBADCHAR ESCAPE/skip