利用OGG从Oracle端发送增量数据到kafka,源端字符集是ZHS16GBK,源端抽取进程配置了SETENV (NLS_LANG = "american_america.AL32UTF8")参数,但是在目标端报错OGG-03533 Conversion from character set zhs16gbk of source column IC_CARD_ID to character set UTF-8 of target column IC_CARD_ID failed because the source column contains a character 'ff' at offset 0 that is not available in the target character set.有朋友遇到过这种情况嘛?
后来找到了解决方法,在目标段的复制进程中加上了REPLACEBADCHAR ESCAPE参数