From: | "Han" <zhouhanok(at)vip(dot)sina(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Problems about ODBC3 datetime |
Date: | 2002-11-21 06:52:37 |
Message-ID: | 20021121065238.3CE824758FE@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
Firstly, I encountered a problem when using SQL_DATE: when I use SQLGetTypeInfo(...,SQL_DATE);
the API returns no record. I debuged the psqlodbc driver and found that the value of the parameter DataType was 91. So I think that the value was changed by the odbc30 Driver Manager. But why don't the psqlodbc add the SQL_TYPE_DATE and other ODBC30 data types support in the array sqlTypes[](in pgtypes.c)?
Secondly, I wander why returning SQL_DATETIME in function pgtype_to_sqldesctype for the three types--SQL_TYPE_DATE, SQL_TYPE_TIME, SQL_TYPE_TIMESTAMP?
Thanks!!!
Han
zhouhanok(at)vip(dot)sina(dot)com
2002-11-21
From | Date | Subject | |
---|---|---|---|
Next Message | Henshall, Stuart - Design & Print | 2002-11-21 13:58:45 | empty text on XP in MS Access |
Previous Message | Hiroshi Inoue | 2002-11-21 00:36:33 | Re: PostgreSQL+ Beta bug? |