Skip to Content.
Sympa Menu

freetds - Re: default textsize

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Darryl Friesen" <Darryl.Friesen AT usask.ca>
  • To: "TDS Development Group" <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: default textsize
  • Date: Mon, 25 Mar 2002 14:51:57 -0600


> When an ODBC application connects to Microsoft® SQL Server(tm), the server
> automatically sets these options for the session:

[snip]


> I really don't know what is meant by "When an ODBC application
> connects ... the server automatically sets...." It's my belief the
> server doesn't know which client API is in use.

[snip snip]

Hmmm... Interesting. I found this in my SQL Server 7.0 Books Online help
file (I searched for 2147483647, which turned up 23 matches -- this is from
the section entitled "Effects of SQL-92 Options"). It seems to indicate
that the ODBC driver issues these statements, not the server.

When the SQL Server ODBC driver connects to SQL Server version
7.0, the server detects that the client is using the ODBC driver
and sets several options on. The options set on by SQL Server 7.0
are the same as those turned on by SET statements when the driver
connects to SQL Server 6.5, except that SQL Server 7.0 also sets
on the CONCAT_NULL_YIELDS_NULL option.

...

The driver issues these statements itself; the ODBC application
does nothing to request them. Setting these options allows ODBC
applications using the driver to be more portable because the
server behavior then matches the SQL-92 standard.

And this from the "SET TEXTSIZE (T-SQL)" page"

The SQL Server ODBC driver and Microsoft OLE DB Provider for
SQL Server automatically set TEXTSIZE to 2147483647 when
connecting.


It's intersting to me that these 2 references state that the _driver_ issues
these commands, not the _server_. If this were really the case, would we
see the odd behaviour we do with TEXT? Perhaps 2147483647 is the default as
well as maximum size no matter what client.

- Darryl

----------------------------------------------------------------------
Darryl Friesen, B.Sc., Programmer/Analyst Darryl.Friesen AT usask.ca
Education & Research Technology Services, http://gollum.usask.ca/
Information Technology Services Division,
University of Saskatchewan
----------------------------------------------------------------------
"Go not to the Elves for counsel, for they will say both no and yes"





Archive powered by MHonArc 2.6.24.

Top of Page