Skip to Content.
Sympa Menu

freetds - Re: [freetds] XML type returns SQL_CHAR type

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sebastien FLAESCH <sf AT 4js.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] XML type returns SQL_CHAR type
  • Date: Fri, 03 Jul 2015 10:10:55 +0200

Ok thank you Frediano.
I can workaround by testing SQL_CHAR + 2147483647
Seb

On 07/02/2015 09:42 PM, Frediano Ziglio wrote:
2015-07-02 10:28 GMT+01:00 Sebastien FLAESCH <sf AT 4js.com>:
Back to the inital problem: For now with 0.95.5 I get invalid SQLDescribeCol
info when using the XML type:

sqltype = SQL_CHAR (1)
precision = 2147483647


Well, not invalid just perhaps wrong. XML is represented as text and
SQL_CHAR is text data. Is not like returning date instead of int.

With other ODBC drivers I get:

sqltype = SQL_SS_XML (-152)
precision = 0

Attached, the TDSDUMP.

You can see:

token.c:1537:tds7_get_data_info:
colname = t
type = 241 (xml)
server's type = 241 (xml)
column_varint_size = 8
column_size = 2147483647 (2147483647 on server)

Seb


I'm changing in master but I don't think to port back to stable
release or at least not before having these stuff all at once. I would
prefer to update as much information as possible

Frediano

On 06/20/2015 12:30 PM, Frediano Ziglio wrote:

Il 19/Giu/2015 11:53, "Sebastien FLAESCH" <sf AT 4js.com> ha scritto:


Seems that when using the XML type, SQLDescribeCol() returns SQL_CHAR,
and
precision=2147483647 ... expected?

BTW what are [N]VARCHAR(MAX) types supposed to return in
SQLDescribeCol()?

Seb


don't remember. Should be part of describecol test.

Frediano
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page