Re: Determining column type

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