http://www.perlmonks.org?node_id=11107780


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

You may need to set the StringColumnLength connection parameter to a higher value. see ERROR: "Informatica ODBC 10170 String data right truncation on data from data source: String data is too big for the driver's data buffer" while running the session with PowerExchange for Cassandra for Cassandra Target in PowerCenter. It appears to be an ODBC driver issue not a DBI one imo

Jason L. Froebe

Tech Blog

  • Comment on Re: Strange DBI/DBD::ODBC behaviour (right truncation of data on ODBC call)

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

    Hi Jason!

    Thanks for the pointer (and the time it took to find that link).
    At the first glance, it does not seem to be the solution - ODBC driver in question (Teradata) does not seem to support such attribute, nor did I find anything with approximately the same meaning. I will, however, investigate, and let you know what I found.

    Regards, Jan