Configuring Unica Optimize for a multi-locale environment

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

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

  • If you are using an Oracle database: When configuring your Unica Optimize server settings, add the following to the Unica 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