Configuring MBCS encoding conversion between your source and target

You can configure encoding conversion between your source and target for MBCS data. CDC Replication converts the character sets during replication.

About this task

CDC Replication automatically detects the default database encoding for source and target columns in a table mapping. If your database supports it, you can choose to override the default encoding for a column if this suits your business needs. If the detected default encodings are appropriate for your business needs, no further changes are necessary.
Note: The MBCS override option is not available for InfoSphere® Classic CDC for z/OS® or the CDC Replication Engine for FlexRep.

For CDC Replication version 6.3 and earlier, Management Console provides standard character sets and encodings. To add additional character sets and encodings, use the CSV (comma separated variable) template that is found in the Advanced preferences of Edit > Preferences. This step is not necessary for CDC Replication version 6.5 and later, which retrieves the supported encodings directly from your datastores.

Procedure

  1. Click Configuration > Subscriptions.
  2. Right-click the table mapping and select Open Details....
  3. Click the Encoding tab.
  4. Depending on your version of CDC Replication, choose from the following options:

    For CDC Replication version 6.5 and later:

    1. If you want to change the encoding for a source column that supports character encoding, click Edit in the Source Encoding area to open the Source Encoding dialog box.
    2. From the list of supported encoding overrides, select the appropriate encoding for your data.

      For example, if your data is stored in Chinese characters, then you can select from either Traditional or Simplified encodings.

    3. To replicate the data with no changes to the encoding, select Override encoding as binary. You must also designate the target column as binary if the source column is binary.
    4. Click OK.
    5. If you want to change the encoding for a target column that supports character encoding, click Edit in the Target Encoding area to open the Target Encoding dialog box.
    6. From the list of supported encoding overrides, select the appropriate encoding for your data. This is the encoding that your source data will be converted to.
    7. If you designated a source column as binary, you must also select Override encoding as binary for the target column.
    8. Click OK.

    For CDC Replication version 6.3 and earlier:

    1. If you want to change the encoding for a source or target column that supports character encoding, select the source column and click Edit to open the Column Encoding dialog box.
    2. In the Source drop down list, select the appropriate encoding for your source column.

      For example, if your data is stored in Chinese characters, then you can select from either Traditional or Simplified encodings.

    3. In the Target drop down list, select the appropriate encoding for your target column. This is the encoding that your source data will be converted to.
    4. Click OK.
  5. Click Save.