From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Han" <zhouhanok(at)vip(dot)sina(dot)com> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Problems about ODBC3 datetime |
Date: | 2002-11-21 14:20:33 |
Message-ID: | EKEJJICOHDIEMGPNIFIJAEMPJMAA.Inoue@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Han
>
> 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)?
Hmm you seem to be right. I would add SQL_TYPE_DATE, SQL_TYPE_TIME
and SQL_TYPE_TIMESTAMP to sqlTypes[].
> 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?
There are SQL_DESC_TYPE and SQL_DESC_CONCISE_TYPE in ODBC3
and
If SQL_DESC_CONCISE_TYPE is set to a concise data type other than an
interval or datetime data type, the SQL_DESC_TYPE field is set to the same
value and the SQL_DESC_DATETIME_INTERVAL_CODE field is set to 0.
If SQL_DESC_CONCISE_TYPE is set to the concise datetime or interval data
type, the SQL_DESC_TYPE field is set to the corresponding verbose type
(SQL_DATETIME or SQL_INTERVAL) and the SQL_DESC_DATETIME_INTER
VAL_CODE field is set to the appropriate subcode.
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2002-11-21 14:35:37 | Re: empty text on XP in MS Access |
Previous Message | Alan R. Johns | 2002-11-21 14:18:05 | Re: empty text on XP in MS Access |