Error received on one particular column where it has a special character:
"Out of sync"
In place of the special character a space is inserted when replicated to the target.
NLS_LANG setting in the env is different from NLS_CHARACTERSET on the database.
To find the current NLS_CHARACTER set for the database, execute:
select PARAMETER, VALUE from NLS_DATABASE_PARAMETERS WHERE PARAMETER LIKE '%CHARACTERSET%';
Source
PARAMETER VALUE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8MSWIN1252
Target
PARAMETER VALUE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8MSWIN1252
For database characterset other than US7ASCII, set NLS_LANG to the correct database characterset in the environment setting before starting sp_cop.
In this example, database parameter values are as follows:
NLS_CHARACTERSET is WE8MSWIN1252
NLS_LANGUAGE is AMERICAN
1. Shutdown Shareplex.
2. Set NLS_LANG as AMERICAN_AMERICA.WE8MSWIN1252 in the env both on source and the target.
3. Start Shareplex.
4. Compare/repair the out of sync table.
