Skip to Content.
Sympa Menu

freetds - Re: [freetds] 2008 Data Types For DBLIB

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] 2008 Data Types For DBLIB
  • Date: Thu, 28 Jul 2011 17:06:04 -0400

On Wed, 27 Jul 2011 08:14:00 -0400
Ken Collins <ken AT metaskills.net> 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




Archive powered by MHonArc 2.6.24.

Top of Page