[Sqlrelay-discussion] SQLRelay/FreeTDS/PHP only returning first 2033 bytes of column

[Michael A. <mi...@mi...>]

Hi there,

Curious problem. If I run an XML query, say SELECT * FROM big_table FOR 
XML AUTO through sqlrsh, it'll show me the full XML result set. However 
if I run the same query through the PHP SQLRelay library, it'll only 
return the first 2033 characters of the result set, chopping off much of 
the output.

I'm using PHP5.2, SQL Server 2005, FreeTDS 0.82RC1, SQLRelay 0.39.4. 
I've had a look at the PHP client library code and can't see any obvious 
places where a column length could be getting set. It doesn't appear to 
be a FreeTDS issue, as it's happily fetching the full result set through 
sqlrsh. I've tried using both prepareQuery and sendQuery and both 
exhibit the same behaviour. Running sqlrcur_getFieldLength($sqlrcurref, 
0, 0) also says 2033 so it would seem to be something at the C++ level. 
Just seems odd that sqlrsh runs the command fine, yet the PHP output is 
clipped.

Any pointers most appreciated. Thanks,
--Michael Adams