FreeTDS Development Group

["Spectron Caribe, Inc." <spectron AT caribe.net>]

Ok, I understand now. You are saying that the drivers call 'set textsize'
internally. Why doesn't freetds call's it. Is 'set textsize' a portable SQL
command? Is it valid in other SQL servers? The SELECT's and INSERT's can
easily go from MSSQL->DB2->Oracle, etc. If it is not portable and only works
with Sybase and MSSQL I think it should be added to the driver so the actual
program can be more portable. If 'set textsize' is portable between SQL
servers just ignore me.

Faw

----- Original Message -----
From: "Lowden, James K" <LowdenJK AT bernstein.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Monday, May 07, 2001 2:10 PM
Subject: [freetds] Re: LONGVARCHAR in freetds JDBC max size is 4096?


> Right.  Any driver can set whatever defaults it pleases by issuing
commands
> to the server when it initializes the connection.  Nulls, for instance,
can
> be handled the "ansi" way or the "old" way.  What the server does by
default
> is a database-level setting, but Microsoft's ODBC driver sets the null
> handling (IIRC) to "ansi".
>
> One could argue that it would be better to be faithful to the database's
> settings (by default) or equally that it is better for the driver to
present
> a consistent behavior across connections to the programmer.  This for
sure:
> when the programmer first bumps into new default settings, it's a
surprise.
> Every time.
>
> Brian's memory serves well, as well:
>
> <snip>
> @@TEXTSIZE (T-SQL)
> Returns the current value of the TEXTSIZE option of the SET statement,
which
> specifies the maximum length, in bytes, of text or image data that a
SELECT
> statement returns.
>
> Syntax
> @@TEXTSIZE
>
> Return Types
> integer
>
> Remarks
> The default size is 4096 bytes (4 KB).
> ...
> </snip>
>
> (We'll just overlook how big a kilobyte is...)
>
> --jkl