odbc-output is truncated!

[Anon]

Hi,

i already asked this question some days ago, but maybe it was too confusing...

I did some research and here is problem:
odbc_result returns the first 3.76KB of a memo-field and the rest is truncated! But
there is no particular sign at this position that could act as a 'end-of-string'! Thus, it has to be some kind of restriction with ms access97, i guess.

---------source code----------
$res=odbc_exec($dbh,"select body from mytable where id=$id");
odbc_fetch_row($res);

echo odbc_result($res,1);

can anybody help, it's REALLY important!

btw, i use PHP4 RC1, WinNT4 and IIS 3

[Anon]

i solved the problem myself!

here is the work-around:

$start = 1;
$size = 255;
$chunk = 'non-empty text';
while ($chunk){
$res=odbc_exec($dbh,"select mid(body, $start, $size) from newsdata where id=$id");
odbc_fetch_row($res);
$chunk=odbc_result($res,1);
$body.=$chunk;
$start += $size;
}

echo $body;

[Anon]

Hi,
You've run into the default read length for ODBC binary results, which is 4096 bytes for some reason. The appropriate method for setting the read size you want would be like this:

odbc_binmode($results, ODBC_BINMODE_PASSTHRU);
odbc_longreadlen($results, 24576);

The number is the size in bytes of the return you want. In this case it is set to 24k. Drop these lines between running your query and reading the results cursor and you're set.

Jason Lee noted this for us a couple of months ago on this board. Hope this helps.

• Scott