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
  • Comment on Re^3: Strange DBI/DBD::ODBC behaviour (right truncation of data on ODBC call)
  • Download Code

Replies are listed 'Best First'.
Re^4: Strange DBI/DBD::ODBC behaviour (right truncation of data on ODBC call)
by jahero (Pilgrim) on Oct 23, 2019 at 07:15 UTC

    Thank you for the learning opportunity, that worked.

    I need to brush my DBI skills a bit more!

[reply]

In Section Seekers of Perl Wisdom