PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

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.

Two things.

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
-- 
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler