Character Set of Database Connection
The Extract and Replicat processes use a session character set when connecting to the database. For Oracle Databases, the session character set is set to the same as the database character set by both Extract and Replicat. For MySQL, the session character set is taken from the SESSIONCHARSET
option of SOURCEDB
and TARGETDB
, or from the SESSIONCHARSET
parameter set globally in the GLOBALS
file. For other database types, it is obtained programmatically. In addition, Oracle GoldenGate processes use a session character set for communication and data transfer between Oracle GoldenGate and the database, such as for SQL queries, fetches, and applying data.