Do you know where your variables are? | |
PerlMonks |
Re^2: DBI::Sybase -retrieving BLOB values from ms-sql questionby derby (Abbot) |
on Jul 07, 2006 at 13:26 UTC ( [id://559788]=note: print w/replies, xml ) | Need Help?? |
That's what I was thinking too but looking at the docs for DBD::Sybase: Note that LongReadLen has no effect when using DBD::Sybase with an MS-SQL server. And further on: 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>"); So I think the $dbh->do( "set textsize <somesize>" ) may be your only option -- but luckily mpeppler is a monk and he'll probably be along soon enough with a better answer.
-derby
In Section
Seekers of Perl Wisdom
|
|