having a problem to get a long string

[yates]

I was trying to get a variable from a postgreSql database using odbc functions, but I may only get the part of the contents. the variable is a very long string, say about 26,000 characters. The test code looks like:
...

$sqlstmt = "select memoStmt from memoTest";
$result = odbc_exec($db, $sqlstmt);
$odbc_result_all($result);
...

every time, it only display the certain amount of characters, it is hard to say exactly how many it shows, but looks like stop showing the result when it reaches the same amount of size.
I am not sure it is a problem caused by the phpscript string declaration, in the php document, it is said that the string can be as long as needed, or it is an odbc function problem caused by odbc_exec() which create a resource variable.
Anyone has the same experience, please reply, Thanks!

Yates

[neuromancer]

First, whats the length it fetches every time?

Try this loop, replace 4095 with the length it fetches each time and <FIELD IN QUESTION, n> with the field offset

$data=odbc_result($sqlstmt,<FIELD IN QUESTION, n>);
while(strlen($data)%4095==0 && empty($data)==false) {
$data=$data.odbc_result($sqlstmt,<FIELD IN QUESTION, n>);
}

[yates]

After a long day struggle, I found out the answer from php.net, the user's manual. Just two line code!

$result = odbc_exec($db, $sqlstmt);

odbc_binmode($result,ODBC_BINMODE_PASSTHRU);
odbc_longreadlen($result_fom_addon, 36000);

$i = 0;
while (odbc_fetch_into($result_fom_addon,$i,$rarr)) {
printf("%s<br>\n", $rarr[0]);
}

so far, as I know, the problem only shows up when using function odbc_result_all() and odbc_fetch_into().
odbc_result() works fine for retriving a very long string variable from DB.

In the end, I have to say the code is contributed by John from [e-mail], Thanks, John!

Yates

[neuromancer]

That will work, but not more than 36000 bytes?

[yates]

You may set the size as long as you want.

[neuromancer]

Yeah, you could. Im just trying to point out that there was a more dynamic solution to the problem.