Configuring Optimize for a multi-locale environment

The multi-locale feature requires some specific settings in your databases.

Optimize supports multiple languages and locales for a single installation. For more information about the multi-locale feature, see the IBM® Unica® Campaign Installation Guide.

If you are using an Oracle database: When configuring your Optimize server settings, add the following to the Optimize server file:

set NLS_LANG=AMERICAN_AMERICA.UTF8

When configuring your database tables, run one of the following scripts from the Campaign/ddl/unicode directory to create system tables:

aco_systab_sqsvr.sql for Microsoft™ SQL Server databases

aco_systab_db2.sql for IBM® DB2® Server databases

aco_systab_ora.sql for Oracle databases