PDO ODBC with SybaseASE - text datatype

[hanisko]

Description

The following code:

<?php
$pdo = new PDO('odbc:Driver={SybaseDriver};Server=xxx;Port=yyy;', user', 'pwd');
$result = $pdo->query('exec some_procedure')->fetchAll();
echo '<pre>';
var_dump($result);
echo  '</pre>';

Resulted in this output:

["test"]=>
NULL
[0]=>
NULL

But I expected this output instead:

["test"]=>
string(4) "test"
[0]=>
string(4) "test"

DB columns with data type text are always NULL https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/X20354.htm

PHP Version

PHP 8.1.29

Operating System

Rocky Linux 9.4 (Blue Onyx)

[cmb69]

Is that also an issue with any of the actively supported PHP versions, i.e. PHP 8.2 or 8.3?

[hanisko]

same wrong results with PHP 8.2.23 and PHP 8.3.11

[cmb69]

Can you please provide a minimal self-contained reproduce example (including the DDL), and an respective ODBC trace? Also it would be good to know if that only happens with stored procedures, or also with regular queries. And: are you using the unixODBC driver manager?

[hanisko]

stored procedures and also regular queries, try this repo, which reproduce issue: https://github.com/hanisko/php_pdo_sybase