Re: 2008 Data Types For DBLIB

On Wed, 27 Jul 2011 08:14:00 -0400
Ken Collins <[email protected]> wrote:

> Does anyone think they will be needing or working on supporting these
> data types [date], [datetime2], [datetimeoffset], and [time] using
> DBLIB? Right now they come back to me as SYBTEXT

Needing, yes, working on, no.  

It's not a db-lib issue.  It's a protocol issue: unless the client
defines itself as using TDS 7.3, the server returns those types as
varchar strings.  The client never sees tbem in binary form.  

See my message of 11 May 2011, "What's new list in FreeTDS 0.91 and
0.92".  

HTH.

--jkl