int2: sql type bug?

Hi,


According to SQLColumns the sql type (DATA_TYPE) for a int2 column is
SQL_INTEGER. According to SQLGetTypeInfo the sql type is SQL_SMALLINT.

Is this a bug?

BTW: I am writing an application that uses the ODBC rather heavily. Is
ODBC actually maintained and is there someone who is prepared to answer
some questions (and accept (source)solutions for problems)?

--
Groeten,

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


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: int2: sql type bug?

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 ?

regards,
Hiroshi Inoue



--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: int2: sql type bug?

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


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc