Skip to Content.
Sympa Menu

freetds - MSSQL for XML

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "DJ Sures" <dj AT securityfocus.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: MSSQL for XML
  • Date: Fri, 31 May 2002 16:56:01 -0400


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.

I am expecting the datatype of XML from MSSQL to be TEXT . However, the
"set textsize" shows it is doing something, just not what it should.

I am wondering if MSSQL returns a datatype/attribute that the sybase 7.0
isn't expecting.

FreeTDS Version: 0.53
DBD-Sybase: 0.91



  • MSSQL for XML, DJ Sures, 05/31/2002

Archive powered by MHonArc 2.6.24.

Top of Page