1. Reference for Oracle GoldenGate
  2. Oracle GoldenGate Common Components
  3. Oracle GoldenGate Parameters
  4. VARWIDTHNCHAR | NOVARWIDTHNCHAR

VARWIDTHNCHAR | NOVARWIDTHNCHAR

Valid For

Extract, Replicat, DEFGEN for Oracle

Description

Use the VARWIDTHNCHAR and NOVARWIDTHNCHAR parameters to control how NCHAR data is written to the trail and interpreted by Replicat.

  • VARWIDTHNCHAR causes an NCHAR, NVARCHAR2, or NCLOB character set to be treated as a variable-length character set (UTF-8).

  • NOVARWIDTHNCHAR causes an NCHAR, NVARCHAR2, or NCLOB character set to be treated as UTF-16.

  • If neither option is specified, the NLS_NCHAR_CHARACTERSET property value from the database is used to determine how an NCHAR, NVARCHAR2, or NCLOB character set is treated.

Default

Use NLS_NCHAR_CHARACTERSET property from database

Syntax

VARWIDTHNCHAR | NOVARWIDTHNCHAR