Skip to Content.
Sympa Menu

freetds - Re: 4096 byte limit on IMAGE?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: 4096 byte limit on IMAGE?
  • Date: Fri, 18 Jun 1999 07:01:35 -0700 (PDT)


Rob Lucier writes:
> OK, I found out how to fix this, but it seems a little sloppy. Is there a
> way to set this value at the initial driver or connection construction?
>
> Workaround:
> for each new statement, set the maximum text(also image) size
> st.execute("set TEXTSIZE 500000 ");
>
> where 500000 is a suitably large number for your data.

The default for Sybase is normally 32k for TEXT/IMAGE columns. I don't
know if jdbc warrants a smaller default.

Michael
--
Michael Peppler -||- Data Migrations Inc.
mpeppler AT peppler.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: ase-linux-list AT isug.com




Archive powered by MHonArc 2.6.24.

Top of Page