Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:98759
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.220.181 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <5e3e3e9b-f5b9-a19e-c4cb-6af0f5985d94@beccati.com>
References: <CADxrgCMB6iz3XX-+yRp0vY0AVWuuL=VwrdLND_78GF0Vhu0K9w@mail.gmail.com>
 <5e3e3e9b-f5b9-a19e-c4cb-6af0f5985d94@beccati.com>
Date: Mon, 10 Apr 2017 11:42:27 -0400
Message-ID: <CADxrgCP1wa_HiDCujXZV1oEN0CXDzg32VkWDoOaa17s-+bQ9UQ@mail.gmail.com>
To: Matteo Beccati <php@beccati.com>
Cc: "internals@lists.php.net" <internals@lists.php.net>
Content-Type: multipart/alternative; boundary=001a1148751894671a054cd1d212
Subject: Re: [PHP-DEV] [RFC] PDO Float Type
From: adam.baratz@gmail.com (Adam Baratz)

--001a1148751894671a054cd1d212
Content-Type: text/plain; charset=UTF-8

>
> That said, I think the proposed type is likely to be misused for
> NUMERIC/DECIMAL fields, which would be pretty bad. Maybe we should also
> add PDO::PARAM_NUMERIC in order to avoid mistakes?
>

Just so I understand your concern, it's that fixed-precision types are
meaningfully different and there could be clashes with other types of
floats? I agree with you on that, but I'm not sure what the right solution
is. There isn't a C type for fixed-precision floats, or even a PHP type.
How would the flow of data work so nothing's lost/altered along the way? My
general thought would be that if fixed-precision matters, then you should
be storing values as strings, that there'd be a whole other set of pitfalls
opened up with a PDO::PARAM_NUMERIC type.

I realize this is all downsides, which isn't the most constructive way to
respond. Happy to talk through details if you have specific suggestions for
how this type would work in practice.

Thanks,
Adam

--001a1148751894671a054cd1d212--