Oracle到GaussDB同步时，当源库和目标库字符集不兼容时，可能会导致数据乱码或者同步失败的场景，可参考表1进行设置。
表1 字符集兼容性 源库/目标库 | UTF8 | GBK | GB2312 | GB18030 |
|---|
US7ASCII | √ | √ | √ | √ |
UTF8 | √ | × | × | × |
AL32UTF8 | √ | × | × | × |
ZHS16GBK | √ | √ | × | √ |
WE8ISO8859P1 | √ | × | × | × |
WE8ISO8859P2 | √ | × | × | × |
WE8ISO8859P4 | √ | × | × | × |
WE8ISO8859P5 | √ | × | × | × |
WE8ISO8859P7 | √ | × | × | × |
WE8ISO8859P9 | √ | × | × | × |
WE8ISO8859P13 | √ | × | × | × |
WE8ISO8859P15 | √ | × | × | × |
WE8MSWIN1252 | √ | × | × | × |
