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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] XML type returns SQL_CHAR type
  • Date: Thu, 2 Jul 2015 20:42:02 +0100

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
>




Archive powered by MHonArc 2.6.24.

Top of Page