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

John Wythe jwythe at silksystems.com
Thu Apr 13 18:39:09 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

Silk Systems Inc.
Tel: (604) 468-1668
Fax:(604) 468-1667
www.silksystems.com

Technology Solutions to Manage Your Business

This message, including any attachments, is intended only for the use of the individual(s) to which it is addressed and may contain information that is privileged and confidential. Any other distribution, copying or disclosure is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify us immediately by reply e-mail and permanently delete this message including any attachments, without reading it or making a copy. Thank you.


More information about the FreeTDS mailing list