Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: "The bind... resulted in truncation" --Solved
Date: Sep 25 1997 4:58PM
Scott Hammond wrote:
> Problem solved. Turned out that sybase was truncating the text field
> of interest to @@textsize, which was defaulting to 32k.
> However, with sybperl, when a record gets this truncation message, the
> entire record is lost-- !ct_fetchable(), rather than receiving the
> record but with a truncated field.
First - the truncation error can be avoided by calling
$dbh->ct_config(CS_SET, CS_OPT_TRUNCIGNORE, CS_TRUE, CS_INT_TYPE);
Second - I have fixed CTlib.xs to attempt to retrieve the rest of the
row when this error occurs.
This will be available in the next release of sybperl which I hope to
have available on CPAN fairly soon.
Michael Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler