From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Oleg <tonal(at)aha(dot)ru> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: ODBC 2.0 Bug: wrong timestamp data type |
Date: | 2018-04-27 03:47:10 |
Message-ID: | 39377eab-da6f-d425-ed80-b7eda1746fa8@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Oleg,
If I provide test drivers, could you it?
regards,
Hiroshi Inoue
On 2018/04/26 1:39, Oleg wrote:
> Hello!
>
> I used the latest driver version (psqlodbc_10_02_0000-x64.zip).
> If your application uses ODBC version 2.0. When you call
> SQLGetTypeInfo, the driver reports supported data types that are not
> available for version 2.0. The first iteration of the result of this
> function for the timestamp data type is SQL_TYPE_TIMESTAMP. If you
> then call SQLBindParameter, ODBC Manager returns s1003 (SQL1).log).
> The error could be corrected (SQL2.log). To verify this, I made
> changes to the function PGAPI_GetTypeInfo: for ODBC 2.0 filter
> unsupported data types.
>
> ---- info.c (1153) ------------------------
> QR_set_field_info_v(res, 18, "INTERVAL_PRECISION", PG_TYPE_INT2, 2);
>
> for (i = 0, sqlType = sqlTypes[0]; sqlType; sqlType = sqlTypes[++i])
> {
> pgType = sqltype_to_pgtype(conn, sqlType);
>
> // Filter unsupported data types
> if (EN_is_odbc2(env) && (sqlType == SQL_TYPE_DATE || sqlType ==
> SQL_TYPE_TIME || sqlType == SQL_TYPE_TIMESTAMP))
> continue;
>
> if (sqlType == SQL_LONGVARBINARY)
> -------------------------------------------
>
> Thank you for listening.
>
> WBR,
> Oleg Tonkikh
From | Date | Subject | |
---|---|---|---|
Next Message | Mahesh Kansara | 2018-04-27 17:02:35 | Re: PostgreSQL 10 Partition Tables: Support through PG Driver |
Previous Message | Inoue, Hiroshi | 2018-04-27 03:42:58 | Re: PostgreSQL 10 Partition Tables: Support through PG Driver |