MSSQL vs. PHP and 7,999 chars

[Anon]

I am trying to fetch 8000+ characters from an MSSQL database and have PHP echo the results, however PHP does not seem to want to show me more than 8000 characters! here is what i am doing:

---

$cur=odbc_exec($cnx, "select note from test where id = '5'");

odbc_binmode($cur, ODBC_BINMODE_PASSTHRU);
odbc_longreadlen($cur, 8000);

$test=odbc_result($cur, 1);

echo "$test";

i have also tried this SQL string:

---

$cur=odbc_exec($cnx, "select SUBSTRING(note, 1, DATALENGTH(note)) from test where id = '5'");

any suggestions? idea? comments?

thanks!