Unescaping single-quote characters v7

In Batch Update Using Prepared Statement (BUP) mode, Replication Server adds an extra single quote character (') when it recognizes text data with single quotes during the WAL-based replication. This results in an additional single quote on the target database.

If there's a possibility that a source database table column contains a single quote character, and you don't want the target database to contain an additional single quote character, set the parameter unescapeSingeQuote to true.

By default, this option is disabled (unescapeSingeQuote=false).

unescapeSingeQuote=true

When set to true, the option removes the single quote character that was added during the WAL-based replication operation in BUP mode.

Note

Enabling the unescapeSingeQuote option adds extra processing for each column, which can increase the replication time. Therefore, enable this option only if there's a possibility that the source data contains single quotes and you configured Replication Server to use WAL-based replication in BUP mode.