Bug #38894 [NoF->ReO]: VARBINARY column fails

Edit report at https://bugs.php.net/bug.php?id=38894&edit=1 ID: 38894 Updated by: cmb@php.net Reported by: m dot karoly at martondesign dot com Summary: VARBINARY column fails -Status: No Feedback +Status: Re-Opened Type: Bug Package: ODBC related Operating System: winxpprof PHP Version: 5.2.5 -Assigned To: cmb +Assigned To: Block user comment: N Private report: N Previous Comments: ------------------------------------------------------------------------ [2017-12-10 11:39:37] tyler dot parcher at swe dot org Experiencing the same issue. I get all the info about the table selected including number of rows in the result which changes depending on my select as expected. "Fetch row" and its variants return null. Windows NT DESKTOP-JLC2DE1 10.0 build 15063 (Windows 10) AMD64 PHP Version 7.1.11 PDO support enabled 4.1.4.9021 ------------------------------------------------------------------------ [2016-07-03 04:22:17] php-bugs at lists dot php dot net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. ------------------------------------------------------------------------ [2016-06-20 16:29:50] cmb@php.net Is that still an issue with recent PHP versions? There have been made quite some improvements to ODBC not too long ago. ------------------------------------------------------------------------ [2007-12-11 19:41:35] m dot karoly at martondesign dot com <?php $conn = new PDO('odbc:RDS', 'user', 'pass'); $qp = $conn->prepare("select de_noteblob from user where rowid = 8598"); $qp->execute(); $results_array = $qp->fetchAll(PDO::FETCH_ASSOC); var_dump($results_array); ?> Expected: Lists an array: de_noteblob is a text de_noteblob = string(24) "Test string, test string" Actually results: Memory pieces with the exact length. de_noteblob = string(24) "????yx>><?php sd|rw4r45" ------------------------------------------------------------------------ [2006-11-08 07:37:56] m dot karoly at martondesign dot com With PDO extension i can fetch the right data! odbc functions not working yet. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=38894 -- Edit this bug report at https://bugs.php.net/bug.php?id=38894&edit=1