FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Ben wrote:
> the 
> central/default config file sets the 'text size' option, but some 
> types of servers don't like the "set text size" command caused by 
> that command (causes failed logins).

I'm not aware of such servers.  Could you be more specific?  

> How can I unset the 'text size' option so that freetds doesn't 
> send the "set text size" command to the server?

Edit the source and re-build, I'm afraid.  IIRC sending "set text size"
was observed behavior in the vendor tools.  It was added because otherwise
text columns are represented as 2^31 bytes on Microsoft servers, leading
to malloc(3) failures.  

If there are indeed servers that choke on it, then we'd obviously need
some kind of fix.  The general solution wouldn't be to remove the existing
behavior.  I'd prefer we understand exactly the conditions under which it
can't be sent, and to document it or, better, detect it and DTRT
automatically.  

--jkl