Re: PostgreSQL pg_query_params, PHP locales, and double data types

From:	Alec Smecher	Date:	Tue, 18 Nov 2008 22:08:42 +0000
Subject:	Re: PostgreSQL pg_query_params, PHP locales, and double data types
References:	1 2 3	Groups:	php.internals
Request:	Send a blank email to internals+get-41989@lists.php.net to get a copy of this message

Alec Smecher wrote:

Lukas Kahwe Smith wrote:
On 17.11.2008, at 17:54, Alec Smecher wrote:
I'm trying to get a PHP bug in the PostgreSQL pg_query_params function reopened; it's been marked bogus (incorrectly IMO). There are lots of details at <http://bugs.php.net/bug.php?id=46408>. If this is in fact bogus, I'd appreciate a little bit of feedback.
Just out of curiosity, did you test this with PDO? Personally I always found the entire setlocale() business entirely painful.
No, I haven't tried PDO; my application requires PHP 4.x compatibility for the time being, unfortunately, and PDO is 5.x-only. BTW, after a little follow-up conversation with Lukas (thanks), I've also confirmed that PDO has the same problem. Both PostgreSQL's number parser and the SQL-92 spec expect numbers to be formatted with a "." for the decimal place.

Regards, Alec Smecher