[freetds] SQL Server 2008 test

Sebastien FLAESCH sf at 4js.com
Thu Mar 6 09:33:58 EST 2008


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)


// 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


More information about the FreeTDS mailing list