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

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Apr 14 07:55:29 EDT 2006


> 
> 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


More information about the FreeTDS mailing list