Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:96544
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.214.53 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <361d013f-8a8c-c91a-1b4f-b2baad92fac2@lsces.co.uk>
References: <CADxrgCPL5vvKJ_9O=8rzNxBQUnVFaKqxNb4gjKDcRvpaTOJxrQ@mail.gmail.com>
 <361d013f-8a8c-c91a-1b4f-b2baad92fac2@lsces.co.uk>
Date: Fri, 21 Oct 2016 17:33:25 -0400
Message-ID: <CADxrgCNCwm9+L0=ophVJghwVeP+YCvijfUA1hv770LdH0ESR+Q@mail.gmail.com>
To: Lester Caine <lester@lsces.co.uk>
Cc: PHP internals <internals@lists.php.net>
Content-Type: multipart/alternative; boundary=001a1146ec86d4b3cf053f66ca63
Subject: Re: [PHP-DEV] [RFC] Driver-Specific PDO Param Types
From: adambaratz@php.net (Adam Baratz)

--001a1146ec86d4b3cf053f66ca63
Content-Type: text/plain; charset=UTF-8

On Wed, Oct 19, 2016 at 12:25 PM, Lester Caine <lester@lsces.co.uk> wrote:

> On 18/10/16 23:05, Adam Baratz wrote:
> > Please share your feedback. I'm happy to hear thoughts about the
> pdo_dblib
> > example, but the RFC is more about the possibility of driver-specific
> types
> > than these particular ones.
>
> The whole point of PDO was that anything that was not available across
> ALL drivers would be emulated in some way, or flagged in a way that does
> not break code, so nothing should be added specifically targeting a
> particular driver if it will cause problems when someone selects a
> different driver to run the same application.
>

I'm starting to think I'm looking at the problem in too narrow a way. Other
supported databases have these column types and likely have these issues.
I'm going to read the PDO code some more and look at the ADOdb type
system[1]. It might be there should be common types for binary and unicode
params, and probably also double params. I'm adding doubles, because it
looks like there's an issue where, since really_register_bound_param()
converts doubles to strings, drivers will bind them as strings and not
doubles. Even though, for example, the MySQL driver attempts to distinguish
between strings and doubles.

I'll follow up when I've gathered more information, but this may be in the
form of a separate RFC.

Thanks,
Adam

---
[1] http://adodb.org/dokuwiki/doku.php?id=v5:dictionary:dictiona
ry_index#summary_of_types

--001a1146ec86d4b3cf053f66ca63--