Skip to Content.
Sympa Menu

freetds - Re: mssql ntext format

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Kaeptn Weltall" <rl AT w4u.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: mssql ntext format
  • Date: Wed, 16 Jan 2002 12:02:15 -0500


It turned out to me, that the
@@textsize is set on connection level.
by default it seems to be 2GB.
thats what i get when i ask from within php:
$res = sybase_query("select @@textsize as sz");
$tmp = sybase_fetch_array($res);
echo "size = ".$tmp["sz"].".";die;

setting the textsize to a lower value with e.g.
$res = sybase_query("set textsize 1048576");
leads to a successfull script run, as long as the value
is not above ~350MB. I tried to get this value sharp,
but in this regions the php sometimes breaks and
sometimes not, using exactly the same value.
magic? anyway, thanks for the help.

Robert




Archive powered by MHonArc 2.6.24.

Top of Page