Skip site navigation (1) Skip section navigation (2)

SQLDescribeCol returns wrong columnsize for macaddress ?

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: SQLDescribeCol returns wrong columnsize for macaddress ?
Date: 2008-01-07 07:31:24
Message-ID: 1199691085.4503.26.camel@panoramix.askesis.nl (view raw or flat)
Thread:
Lists: 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

Next:From: Amit SahaDate: 2008-01-08 12:43:45
Subject: Regarding Connectivity
Previous:From: FabijanicADate: 2008-01-03 18:44:51
Subject: Re: Linux Unicode character size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group