Thread: BUG #2603: SQLDescribeCol return values

The following bug has been logged online:

Bug reference:      2603
Logged by:          Reginaldo Martins
Email address:      regimartins@gmail.com
PostgreSQL version: 8.1.4
Operating system:   Windows XP Professional Edition
Description:        SQLDescribeCol return values
Details:

Hi!

The ODBC driver is PostgreSQL Unicode 8.01.02.00 from 31 of Jan of 2006.

I'm developing in VC++ 6.0 and I use SQLDescribeCol to determine the type of
each field. When I have a field in a database table defined as CHAR(100) the
function gives me -8 as type value! Is this normal?
Plus, if I change to CHAR(255) it returns -10!!

this is the
9c8-c74    EXIT  SQLDescribeCol  with return code 0 (SQL_SUCCESS)
HSTMT               00C52DD0
UWORD                        2
UCHAR *             0x0012E2D8     6] "f_name"
SWORD                       50
SWORD *             0x0012E2D0 (6)
SWORD *             0x0012E41C (-8)
SQLULEN *           0x0012E2C8 (100)
SWORD *             0x0012E420 (0)
SWORD *             0x0012E2CC (1)

=20

> -----Original Message-----
> From: pgsql-bugs-owner@postgresql.org=20
> [mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of=20
> Reginaldo Martins
> Sent: 31 August 2006 11:34
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] BUG #2603: SQLDescribeCol return values
>=20
>=20
> I'm developing in VC++ 6.0 and I use SQLDescribeCol to=20
> determine the type of
> each field. When I have a field in a database table defined=20
> as CHAR(100) the
> function gives me -8 as type value! Is this normal?
> Plus, if I change to CHAR(255) it returns -10!!

Yes:

SQL_WCHAR =3D -8
SQL_WLONGVARCHAR =3D -10

Regards, Dave.

=20


________________________________

    From: Rehgy [mailto:regimartins@gmail.com]=20
    Sent: 31 August 2006 17:04
    To: Dave Page
    Subject: Re: [BUGS] BUG #2603: SQLDescribeCol return values
=09
=09
    Thanks for the information Dave.
    Can you point me to a place where I can find all the return
values for SQLDescribeCol?
=09=20

Buried somewhere in the docs I imagine:
http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/odbc/ht
m/dasdkodbcoverview.asp
=20
I grabbed those two from the UI of Microsofts ODBC test app that I keep
handy.
=20
Regards, Dave.