freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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')
>
-
Is the TEXT datatype for MSSQL supported?,
Myers Carpenter, 02/21/2001
- <Possible follow-up(s)>
- Re: Is the TEXT datatype for MSSQL supported?, Myers Carpenter, 02/21/2001
- Re: Is the TEXT datatype for MSSQL supported?, Brian Bruns, 02/22/2001
- Re: Is the TEXT datatype for MSSQL supported?, Myers Carpenter, 02/22/2001
Archive powered by MHonArc 2.6.24.