BUG #13582: ODBC drvier 9.03.0400 report SQL_NULLDATA when timestamp data has microsecond present

From: john_zhu(at)acl(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13582: ODBC drvier 9.03.0400 report SQL_NULLDATA when timestamp data has microsecond present
Date: 2015-08-20 16:43:57
Message-ID: 20150820164357.7674.70809@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13582
Logged by: John Zhu
Email address: john_zhu(at)acl(dot)com
PostgreSQL version: 9.3.9
Operating system: Windows 7
Description:

Column type: timestamp without time zone
Data: 2000-10-12 11:21:12.345335

When import from ODBC, psqlodbc 9.03.0300-1 driver can successfully import
this data. However, when import using 9.03.0400 driver, the StrLen_or_IndPtr
will return SQL_NULL_DATA, however, the data is presented in the buffer.
Manually remove the microsecond part (e.g. 2000-10-12 11:21:12) will import
successfully.
Binding is using SQL_C_TCHAR type: SQLBindCol(hStmt, 1, SQL_C_TCHAR,
pBuffer, ColLength, ptrInd);

Browse pgsql-bugs by date

  From Date Subject
Next Message mina 2015-08-20 17:51:49 BUG #13583: Documentation "5.8.2. The Public Schema" misleading
Previous Message Tom Lane 2015-08-20 14:02:50 Re: BUG #13580: Fix namespace handling in xpath function, current functions collision