Jump to: navigation, search

UTF-8 Encoding

[FDS: https://intranet.genesys.com/display/RP/Iteration+9.23+%28a%29+Support+for+UTF-8+encoding+by+OCS]

Outbound Contact Server supports UTF-8 encoding of mixed calling lists on Linux and Windows platforms, for the following databases:

OCS Using PostgreSQL 10

Prerequisites

  • PostgreSQL platform: Linux CentOS 7 or later
  • PostgreSQL version: 10.14 or later
  • DB Server version: 8.5.100.07 or later

Database Settings

  • Database encoding: UTF8
  • Database collation: en_US.UTF-8
  • Database character type: en_US.UTF-8


Ocs-Postgre-SQL-DB-settings.png

OCS Using Microsoft SQL Server 2019

Prerequisites

  • Microsoft SQL Server 2019 or later
  • Microsoft ODBC Driver 17 for SQL Server or later
  • DB Server version 8.5.100.07 or later

Database Settings

  • Database collation: Latin1_general_100_CI_AS_KS_WS_SC_UTF-8
    Note: Ensure the SC_UTF-8 suffix is added.

In these examples, genesys_ocs is the database name.

Ocs-db-settings-3.png
Ocs-db-settings-1.png
Ocs-db-settings-2.png

ODBC Settings

Ocs-ODBC-settings-1.png
Ocs-ODBC-settings-2.png
Ocs-ODBC-settings-3.png

DAP Settings

  • UTF-8 for MSSQL: select True.
  • Set the dbclient/utf8-ucs2 option to true.
Ocs-DAP-DB-Info.png
Ocs-DAP-options.png


OCS Using Oracle 19c

Prerequisites

  • Oracle 19c platform
  • Oracle instant client version: 12.2
  • DB Server version: 8.5.100.07 or later
  • OCS version: 8.1.529.07 or later
  • dbserver-less-mode = false

Database Settings

  • Database character set: AL32UTF8 for UTF-8 encoding

Additional scripts to make DB Server working properly

  • The following script files must be placed at the /etc/profile.d directory on the Linux host where DB Server resides: 
NLS_LANG=.UTF8
ORACLE_CLIENT_HOME=/usr/lib/oracle/12.2/client64
ORACLE_HOME=$ORACLE_CLIENT_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_CLIENT_HOME/lib
PATH=$PATH:$ORACLE_CLIENT_HOME/bin

export NLS_LANG
export ORACLE_CLIENT_HOME
export ORACLE_HOME
export LD_LIBRARY_PATH
export PATH

NLS_LANG=.UTF8
ORACLE_CLIENT_HOME=/usr/lib/oracle/12.2/client64
ORACLE_HOME=$ORACLE_CLIENT_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_CLIENT_HOME/lib
PATH=$PATH:$ORACLE_CLIENT_HOME/bin

export NLS_LANG
export ORACLE_CLIENT_HOME
export ORACLE_HOME
export LD_LIBRARY_PATH
export PATH
    • You must modify these scripts if you use a version of the Oracle instant client other than 12.2.
. /etc/profile.d/oracle_env.sh
./multiserver "$@"
    • The multiserver.oracle.sh script must be used in all cases where the multiserver executable generally is used. This script accepts all the same command line parameters as the multiserver executable does.
Comments or questions about this documentation? Contact us for support!