SQLDescribeCol returns wrong columnsize for macaddress ? - Mailing list pgsql-odbc

From Joost Kraaijeveld
Subject SQLDescribeCol returns wrong columnsize for macaddress ?
Date
Msg-id 1199691085.4503.26.camel@panoramix.askesis.nl
Whole thread Raw
List pgsql-odbc
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


pgsql-odbc by date:

Previous
From: FabijanicA@nucorsteel.com
Date:
Subject: Re: Linux Unicode character size
Next
From: "Amit Saha"
Date:
Subject: Regarding Connectivity