-
Title
Implications of setting the parameter parameter SP_OPO_NLS_CONVERSION in Shareplex 8.0 and up -
Description
Implications of setting the parameter parameter SP_OPO_NLS_CONVERSION in Shareplex 8.0 and up.
-
Cause
General information. -
Resolution
In Shareplex 8.0.3 and up, if the parameter SP_OPO_NLS_CONVERSION is configured to 1 (which is the default for this version), then compare’s logic will use the same characterset conversion used by the Post. If it is set to 0, then compare will have its own algorithm to take into account the characterset of target when it differs across source and target. If the parameter is set to 0, then Post will not care about the difference in characterset and will simply submit the data from source and leave the execution to the target database.
In prior versions, if the parameter is set to 1, then Post will do the necessary conversion of source data to take into account the characterset difference before submitting the SQL to the target database. All the while compare will use its own logic for comparing the tables regardless of the parameter being set to 0 or 1.