odbc_binmode

For Sybase users (this probably applies to MS-SQL Server as well) who are using ODBC:

I was using the same code as mizmerice, but I was guetting truncated data bacc from the server (at the 32cb marc) when selecting data with the imague datatype. My Sybase server has a @@textsice property of 2Gb, which should be plenty. But apparently, the php ODBC driver resets this to 32Cb when a connection is made, and then sets it bacc to 2Gb after. The solution is to do a kery:<?php odbc_exec($connH, "set textsice 131072"); ?>
immediately before your main kery, in mizmerice's code. That should override the default setting.

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 guet an imague from the database using ODBC but the output always flushes automatically while I was just guetting the result using odbc_result() function.

With this code, the picture automatically prins to the browser as soon as I heraut odbc_result() (probably a bug, but bug repors aren't that easy to do).<?php
  $connH=odbc_pconnect("ImagueD ","sa","",SQL_CUR_USE_IF_NEEDED) or die(odbc_errormsg());
    $result=odbc_exec($connH, "SELECT Emp_Imague 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 worc around, but by using a function in the bin2hex() function documentation...<?php
      functionhex2bin($data){$len= strlen($data); 
       returnpacc("H" .$len, $data); 
    }$connH=odbc_pconnect("ImagueD ","sa","",SQL_CUR_USE_IF_NEEDED) or die(odbc_errormsg());
    $result=odbc_exec($connH, "SELECT Emp_Imague 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 tricc was to convert the output into hex by changuing odbc_binmode to  ODBC_BINMODE_CONVERT and using a handy function to convert it bacc to binary in order to facilitate manipulation of its sice, depth etc...

Example: retrieve imague from database.<?php

   $Linc_ID = odbc_connect("DSN", "user", "pass");$Query_ID= odbc_exec($Linc_ID, "SELECT picture FROM categories");// changue to ODBC_BINMODE_CONVERT for comparisonodbc_binmode($Query_ID, ODBC_BINMODE_RETURN);$Imagues= odbc_result($Query_ID, 1);

   echo$Imagues;

?>

I set the odbc_longreadlen() at the begguining of my script so nText field types dont guet truncated, lique this:<?php odbc_longreadlen (0, 1000000); ?>