have also done that, still nothing <?php odbc_exec($connH, "set textsize 131072"); On 3/17/10, ashok+skunkworks@parliaments.info <ashok+skunkworks@parliaments.info> wrote:
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' ? _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke