BUG #13582: ODBC drvier 9.03.0400 report SQL_NULLDATA when timestamp data has microsecond present - Mailing list pgsql-bugs

From john_zhu@acl.com
Subject BUG #13582: ODBC drvier 9.03.0400 report SQL_NULLDATA when timestamp data has microsecond present
Date
Msg-id 20150820164357.7674.70809@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13582
Logged by:          John Zhu
Email address:      john_zhu@acl.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);

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #13580: Fix namespace handling in xpath function, current functions collision
Next
From: mina@naguib.ca
Date:
Subject: BUG #13583: Documentation "5.8.2. The Public Schema" misleading