The following bug has been logged online:
Bug reference: 2081
Logged by: Farid Z
Email address: farid@zidsoft.com
PostgreSQL version: 8.1
Operating system: Windows 2000
Description: ODBC numeric(12,6) SQL_C_CHAR clobbered data
Details:
Server 8.1, ODBC driver PostgreSQL ANSI 8.01.01.00
Driver clobbers data retrieving numeric(12,6) into a SQL_C_CHAR buffer (
allocated buffer size 21 bytes ) ANSI application. numeric( 12,4)works ok.
you can download copy of the application from
http://www.zidsoft.com
CREATE TABLE test_numeric
(
price numeric(12,6),
)