Oracle GoldenGate 11g官方文件Administrator’s Guide續二

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

頁的“對特定字元使用轉義序列”。