Re: XML type returns SQL_CHAR type
Sebastien FLAESCH <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Organization | Four Js Development Tools |
| Message-ID | <[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 >