Skip to Content.
Sympa Menu

freetds - [freetds] XML Problems

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Kleehammer <michael AT kleehammer.com>
  • To: FreeTDS <freetds AT lists.ibiblio.org>
  • Subject: [freetds] XML Problems
  • Date: Sat, 29 Sep 2012 21:24:10 -0500

Either there are two problems with selecting XML, or I am seriously
misunderstanding something.

I am using protocol version 7.2

First, when I select from an xml column, SQLDescribeCol reports the sqltype
as SQL_CHAR instead of the expected SQL_SS_XML.

python 7FFF79F56180 EXIT SQLDescribeCol with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x7fc35a616080
SQLUSMALLINT 1
SQLCHAR * 0x7fff59073a30
| s |
SQLSMALLINT 300
SQLSMALLINT * 0x0
SQLSMALLINT * 0x7fff59073a2e (SQL_CHAR)
SQLULEN * 0x7fff59073a20 (2147483647)
SQLSMALLINT * 0x7fff59073a1e (0)
SQLSMALLINT * 0x7fff59073a1c (SQL_NULLABLE)

Second, SQLGetData always returns SQL_SUCCESS, even when the buffer is too
small. It NULL terminates at the given buffer length but gives no
indication more should be read.

Am I missing something?

Thanks,
Michael Kleehammer




Archive powered by MHonArc 2.6.24.

Top of Page