Character Set Compatibility Between Oracle and GaussDB
During synchronization from Oracle to GaussDB, if the character sets of the source and destination databases are incompatible, some data may include garbled characters or the synchronization task may fail. For details, see Table 1.
Source/Destination Database | UTF8 | GBK | GB2312 | GB18030 |
---|---|---|---|---|
US7ASCII | √ | √ | √ | √ |
UTF8 | √ | × | × | × |
AL32UTF8 | √ | × | × | × |
ZHS16GBK | √ | √ | × | √ |
WE8ISO8859P1 | √ | × | × | × |
WE8ISO8859P2 | √ | × | × | × |
WE8ISO8859P4 | √ | × | × | × |
WE8ISO8859P5 | √ | × | × | × |
WE8ISO8859P7 | √ | × | × | × |
WE8ISO8859P9 | √ | × | × | × |
WE8ISO8859P13 | √ | × | × | × |
WE8ISO8859P15 | √ | × | × | × |
WE8MSWIN1252 | √ | × | × | × |
Parent topic: Real-Time Synchronization