|   | php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
| 
 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits              [2011-07-01 16:29 UTC] frozenfire@php.net
 
-Status: Open
+Status: Bogus
  [2011-07-01 16:29 UTC] frozenfire@php.net
  [2011-07-04 06:38 UTC] RQuadling@php.net
 | |||||||||||||||||||||||||||
|  Copyright © 2001-2025 The PHP Group All rights reserved. | Last updated: Fri Oct 31 11:00:01 2025 UTC | 
Description: ------------ I have a MSSQL table with a varbinary(5600) field and i found no way to get it with PDO, got "Invalid sql_display_size" on $stmt->fetch() <?php date_default_timezone_set("Asia/Saigon"); require "connect.php"; $stmt = $MSSQL->prepare("SELECT SCFS5Quest FROM SCFS5Quest WHERE Name = 'hack'"); $stmt->execute(array('hack')); $stmt->bindColumn(1, $lob, PDO::PARAM_LOB,1,PDO::SQLSRV_ENCODING_BINARY); $stmt->fetch(PDO::FETCH_BOUND); //print_r($scf); echo bin2hex($scf); ?> Test script: --------------- <?php date_default_timezone_set("Asia/Saigon"); require "connect.php"; $stmt = $MSSQL->prepare("SELECT SCFS5Quest FROM SCFS5Quest WHERE Name = 'hack'"); $stmt->execute(array('hack')); $stmt->bindColumn(1, $lob, PDO::PARAM_LOB,1,PDO::SQLSRV_ENCODING_BINARY); $stmt->fetch(PDO::FETCH_BOUND); //print_r($scf); echo bin2hex($scf); ?>