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: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Is the TEXT datatype for MSSQL supported?
  • Date: Thu, 22 Feb 2001 09:09:06 -0500 (EST)



This is one I need to track down. Apparently sybase and ms are doing
different things. A pointer to a malloc'ed area of memory is stored in
the current row buffer and the malloc'ed area should be the size of the
text field. However, it appears that MS returns the maximum allowable
size whereas sybase returns the actual size of this particular data.

Brian

On Wed, 21 Feb 2001, Myers Carpenter wrote:

> 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.)
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page