On Wed, Mar 17, 2010 at 11:21 AM, ukuta ken <ukutaken@gmail.com> wrote:
------------------------------------------ <?php
$connH=odbc_pconnect("myDB","me","mypass") or die(odbc_errormsg()); $result=odbc_exec($connH, "select top 1 image from images where id='2'"); if ($result) { odbc_longreadlen($result, 131072); odbc_binmode($result,ODBC_BINMODE_RETURN); $out=odbc_result($result, 1); } ?>
I remember that in older versions of sql server (which was almost a cousin of sybase) you had to set the textsize when retrieving binary data ... otherwise the default textsize returned by the db for blobs and var-binary data types was 32 kilobytes or something like that ... can you set the textsize to a large number before your retreival query and see if it works ? something like 'set textsize 1024000' ?