FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

On Fri, 31 May 2002 16:56:01 -0400 "DJ Sures" <dj AT securityfocus.com>
wrote:
> When I execute the the following query in a stored proc :
> [--- cut ---]
> DECLARE @text varchar(8000)
> set @text=replicate('1', 500)
> set textsize 8000
> SELECT @text as [col1] for XML RAW
> [-----------]
> I receive only 255 characters of the expected (500 + xml garbage). If i
> remove the "set textsize" then i get the obvious "Out of memory!" error
> from freetds.
> 
> FreeTDS Version: 0.53
> DBD-Sybase: 0.91

Are you using SQL Server 2000, and are you sure you're running TDS 7.0? 
The symptom you describe is consistent with a TDS 4.2 connection.  

Try "export TDSVER=7.0" (or similar) before launching your application,
just to make sure.  

HTH.

--jkl