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

Edit report at http://bugs.php.net/bug.php?id=42493&edit=1 ID: 42493 Updated by: mike@php.net Reported by: dave dot lane at gmx dot net Summary: odbc_pconnect: persistent connections with different locales -Status: Open +Status: Bogus Type: Bug Package: ODBC related Operating System: Linux PHP Version: 5.2.4 New Comment: Unforutnately this cannot be influenced by PHP, you need to take care of your locale when useing ODBC. Previous Comments: ------------------------------------------------------------------------ [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