This chapter includes the following sections:
In order to process the data in its native language encoding, Oracle GoldenGate takes into consideration the character set of the database and the operating system locale, if applicable.
Oracle GoldenGate processes catalog, schema, table and column names in their native language as determined by the character set encoding of the source and target databases. This processing is extended to the parameter files and command interpreter, where they are processed according to the operating system locale. These objects appear in their localized format throughout the client interface, on the console, and in files.
The Oracle GoldenGate apply process (Replicat) supports the conversion of data from one character set to another when the data is contained in character column types. Character-set conversion support is limited to column-to-column mapping as performed with the
USEDEFAULTS clauses of a
MAP statement. It is not supported by the column-conversion functions, by
SQLEXEC, or by the
See Mapping and Manipulating Data for more information about character sets, conversion between them, and data mapping.
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 Sybase, Teradata and MySQL, the session character set is taken from the
SESSIONCHARSET option of
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.
Oracle GoldenGate supports text input and output in the default character set of the host operating system for the following:
Command-line input and output
FORMATXML parameters, text files such as parameter files, data-definitions files, error log, process reports, discard files, and other human-readable files that are used by Oracle GoldenGate users to configure, run, and monitor the Oracle GoldenGate environment.
In the event that the platform does not support a required character set as the default in the operating system, you can use the following parameters to specify a character set:
CHARSET parameter to specify a character set to be used by processes to read their parameter files.
CHARSET option of the
DEFSFILE parameter to generate a data-definitions file in a specific character set.
The GGSCI command console always operates in the character set of the local operating system for both keyboard and
OBEY file input and console output.
Oracle GoldenGate supports the use of an escape sequence to represent characters in Unicode or in the native character encoding of the Windows, UNIX, and Linux operating systems. You can use an escape sequence if the operating system does not support the required character, or for any other purpose when needed. For more information about this support, see Support for Escape Sequences.