Re: Column types reported from SQL Server 1008

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 <[email protected]> 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