|
|
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
|
