Re: [GENERAL] Column types via ODBC interface

2000-06-08 Thread Matt Goodall
Tom Lane wrote: Matt Goodall [EMAIL PROTECTED] writes: f10 decimal(9,2) SQL_VARCHAR, 254 SQL_DECIMAL, 9 f11 numeric(9,2) SQL_VARCHAR, 254 SQL_DECIMAL, 9 The 6.5 ODBC driver doesn't know about type numeric, so it returns its default assumption, which is varchar as

Re: [GENERAL] Column types via ODBC interface

2000-06-07 Thread Tom Lane
Matt Goodall [EMAIL PROTECTED] writes: f10 decimal(9,2) SQL_VARCHAR, 254 SQL_DECIMAL, 9 f11 numeric(9,2) SQL_VARCHAR, 254 SQL_DECIMAL, 9 The 6.5 ODBC driver doesn't know about type numeric, so it returns its default assumption, which is varchar as above. The 7.0 version