Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:97328
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.223.180 as permitted sender)
MIME-Version: 1.0
Date: Wed, 7 Dec 2016 16:39:44 -0500
Message-ID: <CADxrgCPNzbSRpaak=LkfMCJfRCUB8u7LLL=jVRzPtcmA-snh+Q@mail.gmail.com>
To: "internals@lists.php.net" <internals@lists.php.net>
Content-Type: multipart/alternative; boundary=94eb2c05e3a8f12ba50543185b76
Subject: PDO::PARAM_DOUBLE
From: adam.baratz@gmail.com (Adam Baratz)

--94eb2c05e3a8f12ba50543185b76
Content-Type: text/plain; charset=UTF-8

If you want to bind a double to a statement, the accepted approach is to
bind as a string:
http://stackoverflow.com/questions/2718628/pdoparam-for-type-decimal

However, this means that prepared statements see these values as strings.
This can cause issues, for example:
http://stackoverflow.com/questions/38105900/sqlite-having-comparison-error

pdo_mysql will actually watch for doubles, but this code will never be
reached since all doubles are cast to strings:
https://github.com/php/php-src/blob/3f25c4228a8f505a000c1ea5751062606247349a/ext/pdo_mysql/mysql_statement.c#L563

Is there a reason PDO::PARAM_DOUBLE doesn't exist?

Thanks,
Adam

--94eb2c05e3a8f12ba50543185b76--