http://qs1969.pair.com?node_id=11107867


in reply to Re^2: Strange DBI/DBD::ODBC behaviour (right truncation of data on ODBC call)
in thread Strange DBI/DBD::ODBC behaviour (right truncation of data on ODBC call)

I can't test this on Terradata but seems to work on MSSQL

my $sth = $dbh->prepare('select lob from table_lob');
$sth->execute();
$sth->bind_col(1, undef, {TreatAsLOB=>1});
$sth->fetch;
$sth->odbc_lob_read(1, \my $data, 65335);
print $data;

[download]
poj

In Section Seekers of Perl Wisdom