in reply to MS SQL (DBD::SyBase) varchar limitation

Try setting the LongReadLen attribute to a suitably high value, e.g.
$dbh->{LongReadLen} = 1000;