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.