{"id":15952,"date":"2024-03-15T12:00:58","date_gmt":"2024-03-15T12:00:58","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/"},"modified":"2025-08-06T22:56:33","modified_gmt":"2025-08-06T22:56:33","slug":"how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/","title":{"rendered":"How to achieve synchronization of Chinese table names i…"},"content":{"rendered":"

Oracle GoldenGate can synchronize Chinese table names by using either a Double Byte Character Set (DBCS) or Unicode character set.<\/p>\n

    \n
  1. Use double-byte character set (DBCS):<\/li>\n
  2. Create a table in Oracle database that supports DBCS, such as using the NVARCHAR2 data type to store Chinese data.<\/li>\n
  3. Make sure to set the “USENLSCHARSET” parameter to a DBCS character set in the GoldenGate configuration file.<\/li>\n
  4. Set up the GoldenGate extract and replicate processes to ensure proper handling of DBCS character sets.<\/li>\n
  5. In the GoldenGate configuration file, define the tables to be synchronized using the correct table and column names.<\/li>\n
  6. Use the Unicode character set:<\/li>\n
  7. Create a table in Oracle database that supports Unicode by using NCHAR or NVARCHAR2 data types to store Chinese data.<\/li>\n
  8. Make sure the “USENLSCHARSET” parameter is set to the Unicode character set in the GoldenGate configuration file.<\/li>\n
  9. Configure GoldenGate’s extraction and replication processes to ensure proper handling of Unicode character sets.<\/li>\n
  10. In the GoldenGate configuration file, use the correct table and column names to define the tables that need to be synchronized.<\/li>\n<\/ol>\n

    Please ensure that the configuration file of GoldenGate is consistent with the character set setting of the database, whether it is using DBCS or Unicode, to guarantee proper synchronization and handling of Chinese table names.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Oracle GoldenGate can synchronize Chinese table names by using either a Double Byte Character Set (DBCS) or Unicode character set. Use double-byte character set (DBCS): Create a table in Oracle database that supports DBCS, such as using the NVARCHAR2 data type to store Chinese data. Make sure to set the “USENLSCHARSET” parameter to a DBCS […]<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[453,1402,299,1404,1403],"class_list":["post-15952","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-development","tag-guide","tag-programming","tag-technology","tag-tutorial"],"yoast_head":"\nHow to achieve synchronization of Chinese table names i... - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn about how to achieve synchronization of chinese table names in oracle goldengate?. Comprehensive guide with examples and best practices.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to achieve synchronization of Chinese table names i...\" \/>\n<meta property=\"og:description\" content=\"Learn about how to achieve synchronization of chinese table names in oracle goldengate?. Comprehensive guide with examples and best practices.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T12:00:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T22:56:33+00:00\" \/>\n<meta name=\"author\" content=\"Isabella Edwards\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Isabella Edwards\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/\"},\"author\":{\"name\":\"Isabella Edwards\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\"},\"headline\":\"How to achieve synchronization of Chinese table names i…\",\"datePublished\":\"2024-03-15T12:00:58+00:00\",\"dateModified\":\"2025-08-06T22:56:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/\"},\"wordCount\":218,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Development\",\"guide\",\"programming\",\"technology\",\"tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/\",\"name\":\"How to achieve synchronization of Chinese table names i... - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T12:00:58+00:00\",\"dateModified\":\"2025-08-06T22:56:33+00:00\",\"description\":\"Learn about how to achieve synchronization of chinese table names in oracle goldengate?. Comprehensive guide with examples and best practices.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to achieve synchronization of Chinese table names i…\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\",\"name\":\"Isabella Edwards\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"caption\":\"Isabella Edwards\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to achieve synchronization of Chinese table names i... - Blog - Silicon Cloud","description":"Learn about how to achieve synchronization of chinese table names in oracle goldengate?. Comprehensive guide with examples and best practices.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/","og_locale":"en_US","og_type":"article","og_title":"How to achieve synchronization of Chinese table names i...","og_description":"Learn about how to achieve synchronization of chinese table names in oracle goldengate?. Comprehensive guide with examples and best practices.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T12:00:58+00:00","article_modified_time":"2025-08-06T22:56:33+00:00","author":"Isabella Edwards","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Isabella Edwards","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/"},"author":{"name":"Isabella Edwards","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd"},"headline":"How to achieve synchronization of Chinese table names i…","datePublished":"2024-03-15T12:00:58+00:00","dateModified":"2025-08-06T22:56:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/"},"wordCount":218,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Development","guide","programming","technology","tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/","name":"How to achieve synchronization of Chinese table names i... - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T12:00:58+00:00","dateModified":"2025-08-06T22:56:33+00:00","description":"Learn about how to achieve synchronization of chinese table names in oracle goldengate?. Comprehensive guide with examples and best practices.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-achieve-synchronization-of-chinese-table-names-in-oracle-goldengate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to achieve synchronization of Chinese table names i…"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd","name":"Isabella Edwards","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","caption":"Isabella Edwards"},"url":"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/15952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=15952"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/15952\/revisions"}],"predecessor-version":[{"id":159224,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/15952\/revisions\/159224"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=15952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=15952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=15952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}