Code Page Compatibility 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.