FreeTDS Development Group

[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