SESSIONCHARSET

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

Syntax

SESSIONCHARSET character_set

character_set

The database session character set.

Example

SESSIONCHARSET ISO-8859-11