Skip to Content.
Sympa Menu

freetds - Re: Is the TEXT datatype for MSSQL supported?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Myers Carpenter" <myers AT fil.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Is the TEXT datatype for MSSQL supported?
  • Date: Thu, 22 Feb 2001 14:09:42 -0500 (EST)


> 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





Archive powered by MHonArc 2.6.24.

Top of Page