Skip to Content.
Sympa Menu

freetds - 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: Is the TEXT datatype for MSSQL supported?
  • Date: Wed, 21 Feb 2001 17:15:36 -0500 (EST)


Although I've seen messages saying that the TEXT datatype is supported with
MSSQL I can't get it to work.

Trying to access a table with php cause a Fatal error which leaves you
browers thinking the server gone. "FATAL: emalloc(): Unable to allocate -
2147483648 bytes" is the error in apache's error.log.

Using sqsh I get:
1> select * from financial_explanations;
2> go
dsp_desc_bind: Memory allocation failure for column #8

2147483647 is the upper limit to how much a TEXT column can hold.

thanks,

myers

(of course I'm realizing that why the heck do I need 2GB of storage and
changing to varchar's which can hold 8kB.)





Archive powered by MHonArc 2.6.24.

Top of Page