ODBC DID connection with Oracle Database returns values without diacritics

Issue

Kofax CCM is installed on Windows Server 2016. You are using an ODBC DID which retrieves data from an Oracle database server. For fields of type C_CHAR, values without diacritics are retrieved. For example instead of Zoë the value Zoe is returned.

Cause

This issue is unrelated to Kofax CCM. This problem is caused by changes in the ODBC layer in Windows Server 2016.

Solution

In the DID document of the affected DID with ODBC connection, change the connection type from ODBC to Oracle. The Oracle DID connection is unaffected. After changing the connection type in the DID, you must still configure the Oracle connection in CCM Core Administrator. See below screenshot for more information on adding the Oracle connection in CCM Core Administrator. After adding the Oracle Connection, a new tab Oracle is added where you can configure the connection.

Level of Complexity 

Easy

Applies to