Re: XML type returns SQL_CHAR type
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4dSRxZG7GXET2_3o-E8YQ-8AARmMq20QUkuF014xg9Leg@mail.gmail.com> |
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 <[email protected]>: > 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 <[email protected]>: >>> >>> 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" <[email protected]> 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 >>>> [email protected] >>>> http://lists.ibiblio.org/mailman/listinfo/freetds >>>> >>> >>> >>> _______________________________________________ >>> FreeTDS mailing list >>> [email protected] >>> http://lists.ibiblio.org/mailman/listinfo/freetds >>> >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds