The ODBC drivers have been updated to incorporate code page translation within their normal data processing. DirectConnect uses this new functionality to simplify code page translation.
For Open DataBase Connectivity (ODBC)-based products, code page translation can take place in two locations:
Between DirectConnect and the target database
Between the client and DirectConnect
The ODBC drivers have been updated to incorporate code page translation within the driver’s normal data processing. DirectConnect uses this functionality to simplify code page translation.
The ODBC driver uses the server-platform-configured code page value as its client code page. Depending on the platform, Windows or UNIX, the server-platform-configured code page value can be found as follows:
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. On the right panel, scroll to the ACP value.
For UNIX, it is the IANAAppCodePage property value.
DirectConnect is an Open Server API and relies on Open Server for datatype conversion. 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.
For proper code page translation, the DirectConnect code page identified by Open Server must match the server-platform-configured code page value. The locales.dat platform configuration identifies the Open Server code page. Configure the locales.dat default for the appropriate platform. Open Server handles code page conversion as follows:
If the client code page matches the Open Server code page no conversion is performed by Open Server.
If the client code page does not match the Open Server code page, Open Server performs the conversion.
The DirectConnect server configuration property called OSCodeSetConvert determines whether DirectConnect enables Open Server to perform code page translation between the client and the ODBC driver. The following are the two values for the new OSCodeSetConvert property:
Yes indicates that DirectConnect performs code page translation.
No indicates that DirectConnect will not perform any code page translation.
With the introduction of the new server configuration property OSCodeSetConvert and the new functionality of the ODBC driver, the following access service properties are no longer available:
UseClientCharset
DefaultClientCodeset
DefaultTargetCodeset
For additional information for the OSCodeSetConvert property, refer to the ECDA and Mainframe Connect Server Administration Guide for DirectConnect.
