Skip to Content.
Sympa Menu

freetds - Re: [freetds] Column types reported from SQL Server 1008

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Column types reported from SQL Server 1008
  • Date: Sun, 20 Nov 2011 09:09:48 +0100

Il giorno sab, 19/11/2011 alle 11.34 -0500, James K. Lowden ha scritto:
> On Fri, 18 Nov 2011 12:58:14 +0300
> Steve Teale <steve.teale AT britseyeview.com> wrote:
> > I have 2 columns that the SMS shows as bigint, a time(7) column, and a
> > date column among others.
> ...
> > The type for the bigint columns comes back as 8 (SQL_DOUBLE), and
> the
> > type name correspondingly as 'float'. The time and date columns are
> > reported as 12 (SQL_VARCHAR) and 'varchar'.
> ...
> > My freetds.conf file has the protocol version as 8.0.
> >
> > What am I missing?
>
> You're missing support for TDS version 7.3.
>
> The TDS client you're using cannot decode the binary format of bigint,
> date, and time types. These types first appeared on SQL Server 2008,
> which brought us TDS 7.3.
>

Bigint is mssql 2000. Perhaps for odbc compatibility it get converted to
double, I'll check

Regards
Frediano Ziglio






Archive powered by MHonArc 2.6.24.

Top of Page