Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:41989 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 19660 invoked from network); 18 Nov 2008 22:08:51 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 18 Nov 2008 22:08:51 -0000 Authentication-Results: pb1.pair.com header.from=alec@smecher.bc.ca; sender-id=unknown Authentication-Results: pb1.pair.com smtp.mail=alec@smecher.bc.ca; spf=permerror; sender-id=unknown Received-SPF: error (pb1.pair.com: domain smecher.bc.ca from 206.190.53.33 cause and error) X-PHP-List-Original-Sender: alec@smecher.bc.ca X-Host-Fingerprint: 206.190.53.33 smtp128.rog.mail.re2.yahoo.com FreeBSD 4.7-5.2 (or MacOS X 10.2-10.3) (2) Received: from [206.190.53.33] ([206.190.53.33:29959] helo=smtp128.rog.mail.re2.yahoo.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 9B/E0-12369-2FC33294 for ; Tue, 18 Nov 2008 17:08:51 -0500 Received: (qmail 15747 invoked from network); 18 Nov 2008 22:08:47 -0000 Received: from unknown (HELO ?192.168.0.103?) (alec@74.210.12.165 with plain) by smtp128.rog.mail.re2.yahoo.com with SMTP; 18 Nov 2008 22:08:47 -0000 X-YMail-OSG: mpeK.jUVM1n2ZYcO8P39zlddn20obVyBApF_xFZOqUHkIFxDyVsAT70fVV64xaGvIQ-- X-Yahoo-Newman-Property: ymail-3 Message-ID: <49233CEA.8050307@smecher.bc.ca> Date: Tue, 18 Nov 2008 14:08:42 -0800 User-Agent: Mozilla-Thunderbird 2.0.0.17 (X11/20081018) MIME-Version: 1.0 To: internals@lists.php.net References: <4921A1D8.70600@smecher.bc.ca> <256A1546-E754-430C-8E71-FCEB6DBDAFC6@pooteeweet.org> <4922E786.8070500@smecher.bc.ca> In-Reply-To: <4922E786.8070500@smecher.bc.ca> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] PostgreSQL pg_query_params, PHP locales, and double data types From: alec@smecher.bc.ca (Alec Smecher) 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 . 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