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