Edit report at http://bugs.php.net/bug.php?id=42493&edit=1
ID: 42493
User updated by: dave dot lane at gmx dot net
Reported by: dave dot lane at gmx dot net
Summary: odbc_pconnect: persistent connections with different
locales
Status: Bogus
Type: Bug
Package: ODBC related
Operating System: Linux
PHP Version: 5.2.4
New Comment:
The bug is about odbc_pconnect i.e. take notice of the "p". As far as I
know the persistence of the connection is handled by php. The problem is
the following:
setlocale(LC_ALL, de_DE);
odbc_pconnect(...)
SQL: select current_timestamp from ... result: date in german format
setlocale(LC_ALL, en_EN);
odbc_pconnect(...)
SQL: select current_timestamp from ... result: date still in german
format
So obviously odbc_pconnect is taking notice of the locale when
connecting, but not when using persistence connections. Thanks for the
speedy reply to the problem by the way (nearly three years...)
Previous Comments:
------------------------------------------------------------------------
[2010-05-20 12:37:40] [email protected]
Unforutnately this cannot be influenced by PHP, you need to take care of
your locale when useing ODBC.
------------------------------------------------------------------------
[2007-08-31 12:34:09] dave dot lane at gmx dot net
Description:
------------
We have an environment where we both use odbc_pconnect and different
locales. DB2 recognises the locale and returns data formatted based on
this locale. That means when we do a setlocale(LC_ALL, de_DE); before we
connect we get float formatted so: 1,23541200000000E+004 and when we do
a setlocale(LC_ALL, en_GB); we get float formatted so
1.23541200000000E+004. This works fine when we use odbc_connect. The
problem is when we use odbc_pconnect connections are recycled without
taking the locale into account. Sometimes we get english when we have
set german and vice versa.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=42493&edit=1
