in reply to Re^2: DBI::Sybase -retrieving BLOB values from ms-sql question
in thread DBI::Sybase -retrieving BLOB values from ms-sql question
You are correct - the OP needs to call $dbh->do("set textsize somevalue"); to get things to work.
The reason for this is that when $dbh->{longReadLen} is updated DBD::Sybase calls a Sybase API call under the cover, and this API call is not one that is compatible between MS-SQL and Sybase.
Michael
In Section
Seekers of Perl Wisdom