Valid For
GLOBALS, valid for MySQL
Description
Use the SESSIONCHARSET parameter to set the database session character set for all database connections that are initiated by Oracle GoldenGate processes in the local Oracle GoldenGate instance. Processes that log into the database include GGSCI, DEFGEN, Extract, and Replicat.
This parameter supports MySQL. The database character set for other databases is obtained programmatically.
The SESSIONCHARSET option of the DBLOGIN command can be used to override this setting for any commands issued in the same GGSCI session. The SESSIONCHARSET option of the SOURCEDB and TARGETDB parameters can be used to override this setting for individual process logins.
Default
Character set of the operating system
Example
SESSIONCHARSET ISO-8859-11