DirectConnect Server and the Target Database

The ODBC driver uses the server-platform-configured code page value as its client code page.

Depending on the platform, you can find the code page value:

On Windows – use the Windows Registry ACP value. To locate the value, use the Registry Editor called regedit to navigate through the registry tree to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\NIs\CodePage, which represents the platform’s ODBC code page. On the right panel, scroll to the ACP value.
On Linux and UNIX – use the locale command to determine the operating system, the platform, and ODBC code page value.

Upon connection to the target, the ODBC driver queries the target database for its code page and compares the value to the server-platform-configured code page:

If the values are not equal, the ODBC driver translates from the server-platform code page to the target code page.
If the values are equal, the ODBC driver does not perform any translation. As an Open Server™ API, the ECDA Option for ODBC relies on Open Server for datatype conversion.