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

[Erik Aase-Remedios <erik@fourfish.com>]

Take a look at LongReadLen
<http://www.minivend.com/minivend/docindex/08.02.SQL_support_via_DBI.html>.
and in 'perldoc DBI'.

-Erik

On Fri, 13 Aug 1999, Johan [iso-8859-1] S&#246;derstr&#246;m wrote:

> ******    message to minivend-users from Johan =?iso-8859-1?Q?S=F6derstr=F6m?= <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.
>