freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Lowden, James K" <LowdenJK AT bernstein.com>
- To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
- Subject: RE: Image fields?
- Date: Wed, 16 Jan 2002 12:35:23 -0500
> From: Gonzalez, Zara E [mailto:gonzalze AT mail.slh.wisc.edu]
> Sent: January 16, 2002 10:51 AM
>
> I admit I am rather ignorant about MSSQL in general having
> used MySQL and Postgresql more...Recently I've switched to
> MSSQL...so please forgive my
> ignorance, but what exactly is sqsh and MS isql?
Zara,
Ignorance is OK. Everyone knows something and no one knows everything.
Please take a another look through the User Guide and FAQ, though. There
are references to SQSH littered all over the the FreeTDS docs.
Microsoft ships a command line utility called "ISQL" as part of their client
tools. It uses db-lib to communicate with the server, whereas the Query
Analyzer uses ODBC. Usually, that distinction is unimportant, but sometimes
the differences surprise people.
Since you're new to MSSQL, you might have overlooked the @@textsize global
variable. You'll want to have a look through Books Online (ie, their docs)
for it. It controls how much of the image field is sent back at once, and
the default value is sometimes 2 GB!
See the FAQ question 7.1 (read "image" where it says "text", same
difference), and also this message:
> From: Kaeptn Weltall [mailto:rl AT w4u.com]
> Sent: January 16, 2002 12:02 PM
> Subject: [freetds] Re: mssql ntext format
>
> 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
Hope that helps.
--jkl
-
Image fields?,
Gonzalez, Zara E, 01/14/2002
- <Possible follow-up(s)>
- RE: Image fields?, Lowden, James K, 01/15/2002
- RE: Image fields?, Franck Martin, 01/15/2002
- RE: Image fields?, Gonzalez, Zara E, 01/16/2002
- RE: Image fields?, Michael Peppler, 01/16/2002
- RE: Image fields?, Lowden, James K, 01/16/2002
Archive powered by MHonArc 2.6.24.