源端oracle,目标端sqlserver,目标端复制进程报错ogg-03533
处理办法:
目标端添加参数后,启动正常。
REPLACEBADCHAR ESCAPE;
REPLACEBADCHAR
Valid For
Extract and Replicat
Description
Use the REPLACEBADCHAR parameter to control the response of the process when a valid code point does not exist for either the source or target character set when mapping character-type columns. By default, the check for invalid code points is only performed when the source and target databases have different character sets, and the default response is to abend. You can use the FORCECHECK option to force the process to check for invalid code points when the source and target databases have the same character set. REPLACEBADCHAR applies globally.
Default
ABORT
Syntax
REPLACEBADCHAR {ABORT | SKIP | ESCAPE | SUBSTITUTE string | NULL | SPACE} [FORCECHECK] [NOWARNING]
ESCAPE
The process replaces the data value with an escaped version of the data value.
Depending on the character set of the source database, the value is output as one of the following:
If the source data is not UTF-16 (NCHAR/NVARCHAR), the output is hexadecimal (\xXX).
If the source data is UTF-16, the output is Unicode (\uXXXX).
相关参考:
https://grepora.com/2018/02/06/error-ogg-03533-conversion-from-character-set-of-source-column/
https://www.cnblogs.com/tan-java/p/5715639.html
最后修改时间:2022-12-30 11:58:28
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。