Thread: SQLDescribeCol returns wrong columnsize for macaddress ?

SQLDescribeCol returns wrong columnsize for macaddress ?

From
"Joost Kraaijeveld"
Date:
Hi,

It appears that SQLDescribeCol returns the wrong column size for the
macaddress datatype: it returns 6. Using that size in SQLBindCol results
in a  SQLFetch error of SQL_SUCCESS_WITH_INFO and the message "Fetched
item was truncated". Changing the size to 18 in SQLBindCol works OK.

Should the return value of SQLDescribeCol indeed be 18 (the length of
the text string "00:00:00:00:00:00" including a '\0') instead of 6?

If not, is there a way to get the exact type of such a column to handle
this case: SQLDescribeCol seems to return SQL_VARCHAR as type so I
cannot differentiate between a real SQL_VARCHAR and a macaddress?

TIA

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl