Configuring for multiple locales on DB2®

To configure Unica 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 Unica 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.