Help Center/ Data Replication Service/ FAQs/ Real-Time Synchronization/ Character Set Compatibility Between Oracle and GaussDB
Updated on 2023-11-13 GMT+08:00

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.

Table 1 Character set compatibility

Source/Destination Database

UTF8

GBK

GB2312

GB18030

US7ASCII

UTF8

×

×

×

AL32UTF8

×

×

×

ZHS16GBK

×

WE8ISO8859P1

×

×

×

WE8ISO8859P2

×

×

×

WE8ISO8859P4

×

×

×

WE8ISO8859P5

×

×

×

WE8ISO8859P7

×

×

×

WE8ISO8859P9

×

×

×

WE8ISO8859P13

×

×

×

WE8ISO8859P15

×

×

×

WE8MSWIN1252

×

×

×