Re: XML type returns SQL_CHAR type
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4fKmksuOAKAUnDizyivPNhwLDAogdR4ijrYuN6E4QDTZg@mail.gmail.com> |
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 >