Use the following guidelines when you configure an environment similar to this case study for ISO 8859-1 data processing:
Verify code page compatibility between the PowerCenter repository database client and the database server.
Verify code page compatibility between the PowerCenter Client and the PowerCenter repository, and between the PowerCenter Integration Service process and the PowerCenter repository.
Set the PowerCenter Integration Service data movement mode to ASCII.
Verify session code page compatibility.
Verify lookup and stored procedure database code page compatibility.
Verify External Procedure or Custom transformation procedure code page compatibility.