Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: BLOBs
Date: Oct 15 1999 6:50PM
Rebecca Voog writes:
> Help, I've just inherited a SybPerl application with a
> major problem...
> I am able to retrieve text and data fields from the
> tables, but when I SELECT a BLOB field, only 17232
> characters come through.... and then I get an error
> LAYER = 1
> ORIGIN = 4
> SEVERITY = 1
> NUMBER = 132.
> Can you point me in the right direction to diagnose
> this problem (i.e. is the the database server? the
> connection, the client? the sybperl version? the
> debian version?)
My guess is that you need to increase the TEXTSIZE value, with
$dbh->ct_sql("set textsize ");
before calling your query. See the section on "set" in the Sybase
command reference manual.
Michael Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: email@example.com