FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

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
>