freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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.