Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:83438
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.192.54 as permitted sender)
MIME-Version: 1.0
Sender: yohgaki@gmail.com
In-Reply-To: <CADxrgCPA-Ehmgr-fn8e9UDMBJE-6pJyiXRuJB9qvQm3RdBZyUw@mail.gmail.com>
References: <CADxrgCPA-Ehmgr-fn8e9UDMBJE-6pJyiXRuJB9qvQm3RdBZyUw@mail.gmail.com>
Date: Sun, 22 Feb 2015 07:12:06 +0900
Message-ID: <CAGa2bXaeT37RFCvhMKLgEymYo8J-DFSvJc0O1gV+Ahs061SU4Q@mail.gmail.com>
To: Adam Baratz <adam.baratz@gmail.com>
Cc: "internals@lists.php.net" <internals@lists.php.net>
Content-Type: multipart/alternative; boundary=001a1135a3dc08f074050fa078e0
Subject: Re: [PHP-DEV] PDO_DBLIB type handling
From: yohgaki@ohgaki.net (Yasuo Ohgaki)

--001a1135a3dc08f074050fa078e0
Content-Type: text/plain; charset=UTF-8

Hi Adam,

On Sat, Feb 21, 2015 at 2:22 AM, Adam Baratz <adam.baratz@gmail.com> wrote:

> This driver returns all column data as a string, regardless of how it's
> represented in the DB. I created a patch for my own use that syncs up the
> type handling with the behavior of the MSSQL extension. This seems like it
> would be of general use. Does anyone have any feedback before I put
> together an RFC? My main question would be whether people would rather have
> this be the default/only behavior, or whether it should be opted into
> via PDO::ATTR_STRINGIFY_FETCHES.
>

Databases return "string" data to return correct data in DB.
Most obvious is "NUMERIC" data type. NUMERIC has any precision.
We may have 128 bit INT in near future also.

So it should return string by default, PHP may convert  types into
PHP native types optionally. Not the other way around. IMHO.

Regards,

--
Yasuo Ohgaki
yohgaki@ohgaki.net

--001a1135a3dc08f074050fa078e0--