Code Page Overview

Code Page Overview

               A code page contains the encoding to specify characters in a set of one or more languages. An encoding is the assignment of a number to a character in the character set. You use code pages to identify data that might be in different languages. For example, if you are importing Japanese data into a mapping, you must select a Japanese code page for the source data.

                 When you choose a code page, the program or application for which you set the code page refers to a specific set of data that describes the characters the application recognizes. This influences the way that application stores, receives, and sends character data. 

Code Page Compatibility
Component Code Page	Code Page Compatibility
Source (including relational, flat   file, and XML file)	Subset of target. Subset of PowerCenter Server.
Target (including relational, XML files, and flat files)	Superset of source. Superset of PowerCenter Server. PowerCenter Server creates external loader data and control files using the target flat file code page.
Lookup and Stored Procedures	Compatible with PowerCenter Server and repository.
PowerCenter Server	Superset of source. Subset of target. Identical to PowerCenter Server operating system and machine hosting pmcmd. Compatible with repository and PowerCenter Client. Compatible with database connection code page used by Lookup and Stored Procedure transformations.
Repository Server	Compatible with repository. Compatible with PowerCenter Client and PowerCenter Server.
Global Repository	Compatible with local repository. Can also be a subset of local repository. Compatible with PowerCenter Client and Server.
Local Repository	Compatible with global repository. Can also be a superset of global repository. Compatible with PowerCenter Client and Server.
Standalone Repository	Compatible with PowerCenter Client and Server.
PowerCenter Client	Compatible with PowerCenter Server and repository.
Machine hosting pmcmd	Identical to PowerCenter Server.