AnsweredAssumed Answered

ODBC 4096 byte limit

Question asked by JasonH on Sep 2, 2009
Latest reply on Sep 3, 2009 by JasonH

Title

ODBC 4096 byte limit

Your post

Ok, I'm stuck. I setup ODBC and everything works great. I'm pulling info through PHP and for the most part everything is fine. As a side note, % wildcard searches are incredibly slow, but that's not why I'm here.

 

I have tried everything I can find but I can't get more than 4k from a picture container.  I have tried a dozen configurations but here's the latest:

 

php.ini - set odbc.defaultlrl = 999999

 

$sql = 'select getas("Items"."Picture Container",\'JPEG\') from "Items Database" where "Items Database"."Part Number" = \'123456\' '; $rs=odbc_exec($conn,$sql); odbc_binmode ($rs, ODBC_BINMODE_PASSTHRU); odbc_longreadlen ($rs, 0); while (odbc_fetch_row($rs))   {       header("Content-type: image/jpeg"); odbc_result($rs, 1);   }

 


 

And no matter what, I only get 4k of the image.

 

Please, does anyone have an idea on how to fix this? I'll try anything! Thanks

Outcomes