Re: int2: sql type bug?

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: int2: sql type bug?
Date: 2008-08-12 04:36:02
Message-ID: 1218515762.4064.132.camel@panoramix.askesis.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On Tue, 2008-08-12 at 13:04 +0900, Hiroshi Inoue wrote:
> Joost Kraaijeveld wrote:
> > Hi,
> >
> >
> > According to SQLColumns the sql type (DATA_TYPE) for a int2 column is
> > SQL_INTEGER.
>
> Here I get SQL_SMALLINT(=5) not SQL_INTEGER(=4) for int2 columns;
> How do you call SQLColumns() and get the DATA_TYPE ?

Ah, sorry for the inconvenience: it appears that that table itself does
not contain the right datatype. After correcting that it returns the
correct value.

Thanks for answering

--
Groeten,

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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2008-08-12 05:30:29 Re: c type of int8 / serial8?
Previous Message Joost Kraaijeveld 2008-08-12 04:24:00 Re: c type of int8 / serial8?