Skip to Content.
Sympa Menu

freetds - RE: MS SQLServer 2000 and "for xml auto" command

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Brian Bruns" <camber AT ais.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: RE: MS SQLServer 2000 and "for xml auto" command
  • Date: Thu, 29 Aug 2002 12:13:26 -0400


> >
> > Ok, I think I know what is going on. In
> > tds7_process_result() there is a
> > switch statement that sets curcol->column_unicodedata if the
> > column type
> > is a unicode capable datatype. ntext is missing from the
> > list. I don't
> > have time (nor am i somewhere convenient) to make a patch
> > right now but we
> > really should be calling is_unicode() on the datatype instead
> > of having
> > this int the switch statement, and then fixing it in the
> > header, nice and
> > clean.
> >
> > Brian
> >
> Yes but after that you should correct column_type to SYBTEXT.
> I think this is a good and correct solution.
> I expect that in the next release (after 0.60) column_unicodedata just
> disappear...
>
> freddy77

Good point, we used to have a column_xtype of something of the sort so we
didn't lose this info. column_type was the cardinal type and column_xtype
was the actual type. I'd prefer to have a tds_get_cardinal_type()
function instead of inlining this switch. If I apply the patch, I'll do
just that, if someone else applies it, please consider doing it.

Brian

Brian




Archive powered by MHonArc 2.6.24.

Top of Page