Configuring for multiple locales on DB2

To configure IBM® Campaign for multiple locales when your system tables are DB2®, you must adjust encoding properties, date/time settings, environment variables, and the application server startup script.

First, identify the DB2 database code set and code page. For localized environments, the DB2 database must have the following configuration:

• Database code set = UTF-8
• Database code page = 1208

When you configure Campaign, make the following adjustments:

• Set the StringEncoding properties to the DB2 database code set value (UTF-8), and
• Set the DB2CODEPAGE DB2 environment variable to the DB2 database code page value.

Both of these adjustments are explained in the following sections.