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: Fri, 3 Jul 2015 13:23:08 +0100

Hi Sebastian,
why don't help with developing/testing for the next release? I hope
will be much sooner than last one. I just push on master changes to
improve XML and SQL_VARIANT.

Frediano


2015-07-03 9:10 GMT+01:00 Sebastien FLAESCH <sf AT 4js.com>:
> 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
>>
>
> _______________________________________________
> 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