Handling Unicode character encoding

If your source column contains character data stored in multibyte, double-byte, or Unicode character set, then you can indicate how CDC Replication handles data from this source column when replicating to a target column.

About this task

Note: This task is only applicable to CDC Replication version 6.3 and earlier.

Management Console provides standard character sets and encodings. If you want to add more character sets and encodings, then you are required to add it to the CSV template that is found in the Advanced preferences in Edit > Preferences.

Before you can configure how CDC Replication handles Unicode data, you need to set one of the following system parameters (depending on the version and platform of CDC Replication) to define the system default method of handling data in Unicode columns:

Procedure

  1. Click Configuration > Subscriptions.
  2. Select the subscription.
  3. Click the Table Mappings view and select the table mapping from the Source Table column.
  4. Right-click and select Open Details....
  5. Click the Encoding tab.
  6. Right-click the source column that supports character handling from the Source Columns list and select Edit Encoding. This opens the Column Encoding dialog box.
  7. If you have set the applicable system parameter (depending on your version of CDC Replication) to use the system default method to handle the character set, select System Default.
  8. If you want to use an encoding for the character set, select from one of the following:
    CHAR
    Select this value if you have set the applicable system parameter to CHAR or true. CDC Replication treats all data in Unicode columns as single-byte characters. Use this encoding when Unicode columns contain single-byte character data.
    NOCHANGE
    Select this value if you have set the applicable system parameter to NO CHANGE or false. CDC Replication treats all data in Unicode columns as a continuous bit stream. Use this encoding when Unicode columns contain non-single-byte character data. NOCHANGE ensures that CDC Replication handles non-single-byte character data in the same way as previous CDC Replication releases.
  9. Click Save.