freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] SQLDescribeCol returns column size has size of data type, instead of size of column (precision).

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] SQLDescribeCol returns column size has size of data type, instead of size of column (precision).
Date: Fri, 14 Apr 2006 13:55:29 +0200

>
> I having a problem with SQLDescribleCOL in freeTDS, in that
> it returns different values for the size of a Column than MS
> SQL does. It appears that it returns the size of the data
> type rather than the precision size of the column.
>
> In particular a Date field returns size 8, whereas MS SQL
> returns 23. A TINY field returns 1 instead of 3.
> Most other data types that are not strings are incorrect as well.
>
> Is this a bug, or have I compiled my freeTDS incorrectly?
>
> John
>
> John Wythe
> Systems Programmer/Engineer
>

Mmm... the first, it's a bug... I wrote a test at
src/odbc/unittests/describecol.c.

freddy77

Re: [freetds] SQLDescribeCol returns column size has size of data type, instead of size of column (precision)., ZIGLIO, Frediano, VF-IT, 04/14/2006