On Jun 16, 2025, at 10:28 AM, Matteo Beccati <[email protected]> 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_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).