http://qs321.pair.com?node_id=663948


in reply to Text retrieved from database column being truncated

You don't say, but I'm guessing that you are using FreeTDS and an MS-SQL data server.

If that is correct then DBD::Sybase's technique for setting LongReadLen (which involves calling ct_options() with the CS_OPT_TEXTSIZE attribute in the ClientLibrary API) does not work.

The work-around:

$dbh-do("set textsize <some_size_in_bytes");
Note that this problem is at the very least hinted at in the DBD::Sybase man page.

Michael