Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:127677
Content-Type: text/plain;
	charset=utf-8
Precedence: bulk
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.600.51.1.1\))
Subject: Re: [PHP-DEV] Interest in a binary parameter type in PDO?
In-Reply-To: <9428eaa3-c339-42df-a6c0-9e59ba7e4bf1@beccati.com>
Date: Mon, 16 Jun 2025 11:21:38 -0300
Cc: "Gina P. Banyard" <internals@gpb.moe>,
 php internals <internals@lists.php.net>
Content-Transfer-Encoding: quoted-printable
Message-ID: <5E49E4ED-EB78-4808-97F8-2C4E969A5F76@cmpct.info>
References: <193E3B72-AE8B-4686-8ACB-9CB68E3947BC@cmpct.info>
 <USKuZs-3w3QvksC1DANK0siF61oUaHe90KxNyBxgq0vVhZscgPHic_t8T7gA4wK1miImOj5-nijRgzAQCHAoczuNn6yDB4j50PR-IF0toU8=@gpb.moe>
 <9428eaa3-c339-42df-a6c0-9e59ba7e4bf1@beccati.com>
To: Matteo Beccati <matteo@beccati.com>
From: calvin@cmpct.info (Calvin Buckley)

On Jun 16, 2025, at 10:28=E2=80=AFAM, Matteo Beccati =
<matteo@beccati.com> wrote:
>=20
> Hi,
>=20
> 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.
>=20

I think PARAM_LOB and PARAM_BINARY 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).=