Skip to Content.
Sympa Menu

freetds - Re: [freetds] Determining column type

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Steve Teale <steve.teale AT britseyeview.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Determining column type
  • Date: Sat, 26 Nov 2011 09:29:28 +0300

Frediano,

I must humbly grovel and apologize. I had screwed up the odbcinst.ini
file, and was in fact using the old Ubuntu version of libtdsodbc.so that
I had intended to replace.

That corrected, BIGINT does work as advertised. Date and time return
SQL_WVARCHAR (-9). I'll build from CVS and see what happens.

Thanks
Steve

On Fri, 2011-11-25 at 15:41 +0100, Frediano Ziglio wrote:
> Mumble mumble.
>
> Personally I would check why BIGINT does not return a BIGINT...
> Currently FreeTDS does NOT support protocol 7.3 (CVS version should),
> that is DATE/TIME/DATETIME2/DATETIMEOFFSET are returned (at WIRE
> level) as varchar. But configuring TDS protocol to 7.1 or 7.2 server
> return BIGINT as... BIGINT!
>
> Frediano






Archive powered by MHonArc 2.6.24.

Top of Page