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 |
√ |
× |
× |
× |
Real-Time Synchronization FAQs
- Can DRS Sync Tables of Different Schemas to the Same Schema?
- Can Online DDL Tools Be Used for Real-time Synchronization?
- Does DRS Support Bidirectional Real-time Synchronization?
- Why Do I Use the SCAN IP Address to Connect to an Oracle RAC Cluster?
- How Do I Check Supplemental Logging of the Source Oracle Database?
- Which Specifications Should I Select for My DRS Task to Synchronize Data to GaussDB(DWS)?
- Suggestions on Synchronizing Data to GaussDB(DWS)
- Character Set Compatibility Between Oracle and GaussDB
- Garbled Characters or Synchronization Failure Due to Incompatible Character Sets
- How Do I Specify the Start Point for DRS Incremental Synchronization?
- What Are Syntax Differences Between MySQL or MariaDB Versions?
- Configuring Remote Connection to a GaussDB Database
- Connection and Port Description for Incremental Synchronization from GaussDB
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore