Truncation error, (DBD: st_fetch/SQLFetch (long truncated) err=1), DBI.pm line 586

[Johan Söderström <johan@farleden.com>]

Hello all mv-users,

I am trying the fetch data from a table with sql. The field I want is a
text-field, and if this field consists of more than 80 characters, I get
the following error, and no output. If there is less than 80 characters,
there is no problem.
I don't want to use varchar(255) because I need more than 255 positions.

error:
======
DBD::ODBC::st fetchrow_array failed: [Microsoft][ODBC SQL Server
Driver]String d
ata, right truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated)
err=1)
 at /mvend/lib/Vend/Table/DBI.pm line 586.
======

I can't be the first one who runs into this problem, so I am thankful for
any help I can get.