note 60557 added to function.odbc-binmode

I am currently using an SQL Server 2000 used as a datasource for ODBC access, Testing PHP scripts from an Apache 2 server running on Windows 2000. I was trying to get an image from the database using ODBC but the output always flushes automatically while I was just getting the result using odbc_result() function. With this code, the picture automatically prints to the browser as soon as I hit odbc_result() (probably a bug, but bug reports aren't that easy to do). <?php $connH=odbc_pconnect("ImageDB","sa","",SQL_CUR_USE_IF_NEEDED) or die(odbc_errormsg()); $result=odbc_exec($connH, "SELECT Emp_Image FROM tblEmployeePics WHERE Emp_Id=547"); if ($result) { odbc_longreadlen($result, 131072); odbc_binmode($result,ODBC_BINMODE_PASSTHRU); //upon calling this, the output flushes out to the browser... made me scratch $m_FValue=odbc_result($result, 1); } ?> ...after 48 hours of scratching I finally made a work around, but by using a function in the bin2hex() function documentation... <?php function hex2bin($data){ $len = strlen($data); return pack("H" . $len, $data); } $connH=odbc_pconnect("ImageDB","sa","",SQL_CUR_USE_IF_NEEDED) or die(odbc_errormsg()); $result=odbc_exec($connH, "SELECT Emp_Image FROM tblEmployeePics WHERE Emp_Id=547"); if ($result) { odbc_longreadlen($result, 131072); odbc_binmode($result,ODBC_BINMODE_CONVERT); $m_FValue=odbc_result($result, 1); $out=hex2bin($m_FValue); } ?> The trick was to convert the output into hex by changing odbc_binmode to ODBC_BINMODE_CONVERT and using a handy function to convert it back to binary in order to facilitate manipulation of its size, depth etc... ---- Manual Page -- http://www.php.net/manual/en/function.odbc-binmode.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+60557 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+60557&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+60557&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+60557&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+60557&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+60557&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+60557&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+60557&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+60557&report=yes Search -- http://master.php.net/manage/user-notes.php