The following bug has been logged online: Bug reference: 2081 Logged by: Farid Z Email address: [EMAIL PROTECTED] 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), ) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend