Operating System (OS) Character Set
For LINUX system, Oracle GoldenGate 11.2 uses the LC_ALL environment variable. For Windows, Oracle GoldenGate use the system code page. By default, the OS character set is UTF-8.
This is database dependent. In general, the database session character set is the same as the database character set. For MySQL/Sybase/Teradata database, user can overwrite the session character set with the SESSIONCHARSET parameter set up in either of the followings:
- GLOBAL: SESSIONCHARSET parameter
- Parameter file: SESSIONCHARSET parameter
i.e. sourcedb xxx userid xxx password xxx sessioncharset xxx.
Replicat - Source Database Character Set
Oracle GoldenGate replicat determine the source database character set from the trail header (in higher priority) and the definition file. The conversion on replicat side should be automatic. User can overwrite the source database character set with SOURCECHARSET OVERRIDE parameter in Oracle GoldenGate 12c (12.1.2).
Replicat - Target Database Character Set
Oracle GoldenGate performs a query after connecting to the target database and get the target database character set.