Is the TEXT datatype for MSSQL supported?
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.
More information about the FreeTDS