CHAPTER 2 第二章
Oracle GoldenGate globalization support
Oracle GoldenGate全球化支持
Oracle GoldenGate globalization support enables the processing of data in its native
language encoding. The following points highlight this support
Oracle GoldenGate全球化支持允许以其本机语言编码处理数据。以下几点强调了这种支持
Preserving the character set
保留字符集
In order to process the data in its native language encoding, Oracle GoldenGate takes into
consideration the character set encoding of the database, and the operating system locale
for parsing parameter files and command line interpreter processing.
为了以本机语言编码处理数据，Oracle GoldenGate考虑了数据库的字符集编码，以及用于解析参数文件和命令行解释器处理的操作系统区域设置。
Character set of database structural metadata
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.
数据库结构元数据的字符集
Oracle GoldenGate处理由源和目标数据库的字符集编码确定的以其本机语言表示的目录、架构、表和列名。
此处理扩展到参数文件和命令解释器，它们根据操作系统区域设置进行处理。这些对象以其本地化格式出现在整个客户端
界面、控制台和文件中。
Character set of character-type data
字符类型数据的字符集
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
COLMAP or USEDEFAULTS clauses of a TABLE or MAP statement. It is not supported by the
column-conversion functions, by SQLEXEC , or by the TOKENS feature.
For additional information about character sets, conversion between them, and data
mapping, see “Mapping and manipulating data” on page 140.
Oracle GoldenGate 应用进程（Replicat）支持当数据包含在字符列类型中时，将数据从一个字符集转换为另一字符集
字符集转换支持仅限于使用TABLE或MAP语句的COLMAP或USEDEFAULTS子句执行的列到列映射。它不支持 列转换函数，
按SQLEXEC或按标记功能。 有关字符集、字符集与数据之间的转换的其他信息 映射，请参阅第140页的“映射和操作数据”。
Character set of database connection
数据库连接字符集
The Extract and Replicat processes use a session character set when connecting to the
database. For Oracle, the session character set is set to the same as the database character
set for the Extract process and is determined using NLS_LANG for the Replicat process. For
Sybase, Teradata and 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.
提取和复制进程在连接到数据库时使用会话字符集。对于Oracle，会话字符集设置为与提取进程的数据库字符集相同，并
使用NLS_LANG为复制进程确定。对于Sybase、Teradata和MySQL，会话字符集取自SOURCEDB和TARGETDB的SESSIONCHARSET
选项，或者取自全局文件中全局设置的SESSIONCHARSET参数。对于其他数据库类型，它是以编程方式获取的。此外，Oracle GoldenGate
进程使用会话字符集在OracleGoldenGate和数据库之间进行通信和数据传输，例如用于SQL查询、获取和应用数据
Character set of text input and output
Oracle GoldenGate supports text input and output in the default character set of the host
operating system for the following:
Oracle GoldenGate在主机操作系统的默认字符集中支持以下文本的输入和输出：
● Console 控制台
● Command-line input and output 命令行输入输出
● FORMATASCII , FORMATSQL , 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.
●FORMATASCII、FORMATSQL、FORMATXML参数、文本文件（如参数文件、数据定义文件、错误日志、进程报告、丢弃文件）和其他供Oracle GoldenGate用户用于配置、运行和监视Oracle GoldenGate环境的可读文件
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.
●HARSET参数指定进程用于读取其参数文件的字符集。
● CHARSET option of the DEFSFILE parameter to generate a data-definitions file in a specific character set.
●DEFSFILE参数的CHARSET选项，用于在特定字符集中生成数据定义文件
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.
GGSCI命令控制台始终在本地操作系统的字符集中操作键盘和遵从文件输入和控制台输出。
Using Unicode and native characters
使用Unicode和本机字符
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, see
“Using escape sequences for specific characters” on page 143.
Oracle GoldenGate支持使用转义序列来表示Unicode或Windows、UNIX和Linux操作系统的本机字符编码中的字符。
如果操作系统不支持所需字符，则可以使用转义序列，或者在需要时用于任何其他目的。有关详细信息，请参阅第143
页的“对特定字符使用转义序列”。