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

Поиск
Список
Период
Сортировка
От john_zhu@acl.com
Тема BUG #13582: ODBC drvier 9.03.0400 report SQL_NULLDATA when timestamp data has microsecond present
Дата
Msg-id 20150820164357.7674.70809@wrigleys.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #13580: Fix namespace handling in xpath function, current functions collision
Следующее
От: mina@naguib.ca
Дата:
Сообщение: BUG #13583: Documentation "5.8.2. The Public Schema" misleading