Is the TEXT datatype for MSSQL supported?

Myers Carpenter myers at fil.org
Thu Feb 22 14:09:42 EST 2001


> Ummm... ok... should have read thru the archives... I found the tip
> about  using 'set textsize 555555555;' to allow you to use TEXT
> datatypes.   555555555 is a number I came up with trying diffrent
> options in sqsh.

And driving to work this morning I realized why 555555555 works (it was a 
very weird number, since it's not near any int/long boundaries):  The 
machine I was working on has 512 MB of RAM + 100MB swap. :)  

The moral is: you'll have to tune that number to your application.

myers




More information about the FreeTDS mailing list