cooperman,
Try:
$dbh->do("set textsize <somesize>");
From this site:
Sybase defaults the TEXTSIZE attribute (aka LongReadLen) to 32k, but MS-SQL 7 doesn't seem to do that correctly, resulting in very large memory requests when querying tables with TEXT/IMAGE data columns. The work-around is to set TEXTSIZE to some decent value via $dbh->{LongReadLen} (if that works - I haven't had any confirmation that it does) or via $dbh->do(``set textsize <somesize>'');
| [reply]
[d/l] |
cbro,
I have already tried set textsize both from a ->do(...); statement and in the freetds.conf file. No dice. I am currently fiddling with the freetds nightly development build. I am hoping maybe something was advanced in 0.62 work.
-Marc
| [reply]
[d/l]
[select] |