Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:127680
Feedback-ID: i6f4c46c2:Fastmail
Message-ID: <3504c6ee-fc7a-4424-96d5-a60eb030628f@beccati.com>
Date: Mon, 16 Jun 2025 16:35:53 +0200
Precedence: bulk
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: [PHP-DEV] Interest in a binary parameter type in PDO?
To: Calvin Buckley <calvin@cmpct.info>
Cc: "Gina P. Banyard" <internals@gpb.moe>,
 php internals <internals@lists.php.net>
References: <193E3B72-AE8B-4686-8ACB-9CB68E3947BC@cmpct.info>
 <USKuZs-3w3QvksC1DANK0siF61oUaHe90KxNyBxgq0vVhZscgPHic_t8T7gA4wK1miImOj5-nijRgzAQCHAoczuNn6yDB4j50PR-IF0toU8=@gpb.moe>
 <9428eaa3-c339-42df-a6c0-9e59ba7e4bf1@beccati.com>
 <5E49E4ED-EB78-4808-97F8-2C4E969A5F76@cmpct.info>
Content-Language: it
In-Reply-To: <5E49E4ED-EB78-4808-97F8-2C4E969A5F76@cmpct.info>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
From: php@beccati.com (Matteo Beccati)

Hi Calvin,

On 16/06/2025 16:21, Calvin Buckley wrote:
> On Jun 16, 2025, at 10:28 AM, Matteo Beccati <matteo@beccati.com> wrote:
>>
>> Hi,
>>
>> as mentioned in https://github.com/php/php-src/pull/15949 I still think that PARAM_LOB can safely be used as identifier for binary data, as pdo_mysql and pdo_pgsql do.
>>
> 
> I think PARAM_LOB and PARAM_LOB are orthogonal.
> 
> Using i.e. ODBC as an example:
> 
>            +----------+------------+
>            |  string  |   binary   |
> +---------+----------+------------+
> |   LOB   | SQL_CLOB |  SQL_BLOB  |
> +---------+----------+------------+
> | not LOB | SQL_CHAR | SQL_BINARY |
> +---------+----------+------------+
> 
> Especially since LOBs may have different semantics (i.e. needing to be
> treated as a stream).


In an ideal world, yes.

But I fear that ship has sailed, as the most used drivers have been 
using PARAM_LOB for binary fields since PDO has been designed, as far as 
I know.

Perhaps we can make that clear by aliasing PARAM_BINARY to PARAM_LOB and 
fix the implementation for broken drivers?


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/