ODBC drivers incorporate code page translation within their normal data processing. The ECDA Option for ODBC uses this functionality to simplify code page translation.
For ODBC-based products, code page translation can take place in two locations:
Between the DirectConnect server and the target database
Between the client and DirectConnect server
The ODBC driver uses the server-platform-configured code page value as its client code page. Depending on the platform, the server-platform-configured code page value can be found:
For Windows, in 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.
For Linux and UNIX, you can 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.
For proper code page translation, the ECDA code page identified by Open Server must match the server-platform-configured code page value. The default platform in the locales.dat configuration file identifies the Open Server code page.
The DirectConnect server configuration property called OSCodeSetConvert determines whether the ECDA Option for ODBC allows Open Server to perform code page translation between the client and the DirectConnect server. Values for the OSCodeSetConvert property are:
Yes indicates that the DirectConnect server will perform code page translation.
No indicates that the DirectConnect server will not perform any code page translation.
