Informix - Problem description
Problem IT40016 | Status: Closed |
ODBC SHOULD IGNORE DB_LOCALE & CLIENT_LOCALE VALUES SET IN THE ENVIRONMENT/SETNET | |
product: | |
IBM CSDK / 5724C2381 / 450 - CSDK 4.50 | |
Problem description: | |
As per the documentation for DB_LOCALE & CLIENT_LOCALE, it says, "Important: The setting of the DB_LOCALE environment variable in the operating system environment and in Setnet32 are ignored by IBM Informix ODBC Driver.", however, if you have DB_LOCALE/CLIENT_LOCALE set in the environment/setnet, it still uses the same and makes the connection fail, consider the below scenario. 1. Database is created in en_US.UTF8 code page. 2. ODBC application sets DB_LOCALE and CLIENT_LOCALE to en_US.UTF8 in connection string/DSN. 3. User sets DB_LOCALE and/or CLIENT_LOCALE to en_US.819 in the environment/setnet. 4. Run the ODBC application, it fails with -23197 error code. This is because it considers and gives precedence to DB_LOCALE set in the environment/setnet than actually using from the connection string/DSN/SQLSetConnectAttr(SQL_INFX_ATTR_DBLOCALE). This is against what its documented and should be fixed. If you don't set DB_LOCALE/CLIENT_LOCALE in the environment/Setnet then all works fine. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * n/a * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * n/a * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Comment | |
The documentation states that CLIENT_LOCALE/DB_LOCALE set in the environment ARE ignored by the Informix ODBC driver: https://www.ibm.com/docs/en/informix-servers/12.10?topic=SSGU8G_ 12.1.0/com.ibm.odbc.doc/ids_odbc_030.htm | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.02.2022 28.11.2022 28.11.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |