Thread: 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
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
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