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: sybperl help..
Date: Feb 3 1998 3:35PM

Thuy Mai wrote:
> 
> hi:
> 
> I am using sybperl (CTlib).  Everything work just fine,
> except when I query a large text field (during ct_fetch).
> I receive this message:
> 
> Open Client Message:
> Message number: LAYER = (1) ORIGIN = (4) SEVERITY = (1) NUMBER = (132)
> Message String: ct_fetch(): user api layer: internal common library error: The b
> ind of result set item 6 resulted in truncation.

The general problem is that Sybase truncates TEXT/IMAGE columns
at 32k bytes by default.

This behaviour can be changed by using the SET TEXTSIZE option, or
calling ct_option() with the CS_TEXTSIZE parameter.

Look up SET TEXTSIZE in the Sybase manuals for more information.

Michael
-- 
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler