Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:98839 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 66017 invoked from network); 21 Apr 2017 16:40:11 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 21 Apr 2017 16:40:11 -0000 Authentication-Results: pb1.pair.com header.from=lester@lsces.co.uk; sender-id=pass Authentication-Results: pb1.pair.com smtp.mail=lester@lsces.co.uk; spf=pass; sender-id=pass Received-SPF: pass (pb1.pair.com: domain lsces.co.uk designates 185.153.204.204 as permitted sender) X-PHP-List-Original-Sender: lester@lsces.co.uk X-Host-Fingerprint: 185.153.204.204 mail4.serversure.net Linux 2.6 Received: from [185.153.204.204] ([185.153.204.204:43401] helo=mail4.serversure.net) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 53/00-65481-9E53AF85 for ; Fri, 21 Apr 2017 12:40:10 -0400 Received: (qmail 10950 invoked by uid 89); 21 Apr 2017 16:40:05 -0000 Received: by simscan 1.3.1 ppid: 10944, pid: 10947, t: 0.0401s scanners: attach: 1.3.1 clamav: 0.96/m:52/d:10677 Received: from unknown (HELO ?10.0.0.7?) (lester@rainbowdigitalmedia.org.uk@81.138.11.136) by mail4.serversure.net with ESMTPA; 21 Apr 2017 16:40:05 -0000 To: internals@lists.php.net References: <5e3e3e9b-f5b9-a19e-c4cb-6af0f5985d94@beccati.com> <8923084a-a357-91e9-44b5-52a4af0a5df1@beccati.com> <86e4681f-9030-80fc-896b-56255c4b84c7@beccati.com> <36b72547-db1d-125b-62e4-bb3290972dbd@beccati.com> Message-ID: <78700ca5-2e99-94f8-5094-69c8bc2e54c3@lsces.co.uk> Date: Fri, 21 Apr 2017 17:40:05 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.8.0 MIME-Version: 1.0 In-Reply-To: <36b72547-db1d-125b-62e4-bb3290972dbd@beccati.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] [RFC] PDO Float Type From: lester@lsces.co.uk (Lester Caine) On 21/04/17 12:08, Matteo Beccati wrote: > If some database APIs aren't capable of properly handling fixed > precision, it is their fault (dblib?, firebird?), but PDO shouldn't > behave like the less capable ones. The whole point of PDO was that it would provide a consistent DATA interface to any engine and that the base should be what can be provided transparently across all drivers. It should certainly not mess things up by providing a floating point value where a fixed precision number is being used. The problem is that PHP can't handle the data that databases do actually produce and none of the type systems being bodged in currently can handle fixed precision numbers, so leave these as strings and allow third party add-ons to properly process this data. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk