Bug #42493 [Bgs]: odbc_pconnect: persistent connections with different locales

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: Excuse me? No I don't find it funny. The fact is the reply took 3 years. If you don't want to fix the problem or even understand it then fine don't. It is still a Unified ODBC problem though. If the connect routine takes notice of the locale when first connecting and not by any subsequent connections that is a bug. End of story. A fix would be to set the current locale on the existing connection or to keep track of the locales corresponding to the open connections in the pool and open a new connection when the current locale doesn't fit any in the pool. We had to stop using pconnect and implemenent our own pool doing exactly this. Previous Comments: ------------------------------------------------------------------------ [2010-05-20 14:08:23] mike@php.net thanks for wasting our time, by the way. (You probably find such comments funny, eh?) The connection is just opened once. ------------------------------------------------------------------------ [2010-05-20 13:52:20] dave dot lane at gmx dot net 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...) ------------------------------------------------------------------------ [2010-05-20 12:37:40] mike@php.net 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