|
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) |
