global_unicode_as_char

This system parameter indicates the default method of treating data in defined Unicode columns.

For each CDC Replication installation on a server, this system parameter defines the system default method of treating data in Unicode columns. If a Unicode column is set to System Default on the Encoding tab of the Mapping Details view in Management Console, CDC Replication uses the method for processing Unicode columns that you select in this system parameter.

Applies to

Source datastores

Values

Set this parameter to one of the following values:

true: CDC Replication treats all data in Unicode columns as single-byte characters. Use this setting when Unicode columns contain single-byte character data.
false: CDC Replication treats all data in Unicode columns as a continuous bit stream. Use this setting when Unicode columns contain non-single-byte character data. Setting this system parameter to false ensures that CDC Replication handles non-single-byte character data in the same way as previous CDC Replication releases.; Setting this parameter to false does not ensure that replicated non-single-byte character data in Unicode columns are represented properly on the target. For replicated non-single-byte character data, you may have to apply user exit programs or other customizations to properly represent data in Unicode columns.

Default Setting

false

Note: The following SQL Server data types are considered to be Unicode columns and are therefore affected by the value assigned to this system parameter:

NCHAR
NVARCHAR