FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> Hi all,
> 
> FYI I have just installed SQL Server 2008 "Katmai" and do some tests.
> 
> This 2008 version supports new datatypes:
> 
>    DATE
>    TIME(n)
>    DATETIME2(n)
>    DATETIMEOFFSET(n)
> 
> I found this in sqlncli.h:
> 
> // Driver specific SQL data type defines.
> // Microsoft has -150 thru -199 reserved for Microsoft SQL 
> Server Native Client driver usage.
> #define SQL_SS_VARIANT                      (-150)
> #define SQL_SS_UDT                          (-151)
> #define SQL_SS_XML                          (-152)
> #define SQL_SS_TABLE                        (-153)
> #define SQL_SS_TIME2                        (-154)
> #define (-155)
> 

Thanks for informations. Could you be so kind to do some select with
these new types using native client and capturing network trace?
We know already VARIANT type (it should be documented in tds.html) but
others type are not known.

> 
> // New Date Time Structures
> // New Structure for TIME2
> typedef struct tagSS_TIME2_STRUCT
>      {
>      SQLUSMALLINT hour;
>      SQLUSMALLINT minute;
>      SQLUSMALLINT second;
>      SQLUINTEGER fraction;
>      }        SQL_SS_TIME2_STRUCT;
> 
> // New Structure for TIMESTAMPOFFSET
> typedef struct tagSS_TIMESTAMPOFFSET_STRUCT
>      {
>      SQLSMALLINT year;
>      SQLUSMALLINT month;
>      SQLUSMALLINT day;
>      SQLUSMALLINT hour;
>      SQLUSMALLINT minute;
>      SQLUSMALLINT second;
>      SQLUINTEGER fraction;
>      SQLSMALLINT timezone_hour;
>      SQLSMALLINT timezone_minute;
>      }        SQL_SS_TIMESTAMPOFFSET_STRUCT;
> 
> 
> Sooner or later this should be supported.
> 
> Cheers
> Seb

bye
  freddy77