|
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 GroupAll rights reserved. |
Last updated: Fri Dec 19 03:00:02 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); ?>