SQLColumns() returning

I am using the Microsoft Driver for Oracle (Microsoft ODBC for Oracle) and trying to access ODBC API.

I am using SQLColumns(), along with calls to SQLBindCol() and SQLFetch(), to get the column names and corresponding properties for the columns in a given table. It seems that all numeric types return a length which is 2 greater than the length which is set for the database. For example, if a field is Numeric(10), the length of the field, as retrieved by SQLColumns() is 12. Similarly, a field defined as being of type Numeric(3) in the database has a length of 5 according to the data retrieved with SQLColumns().

Is this simply the way Oracle works or is there a way around this?

Thanks in advance,

Mark Received on Wed Jul 28 1999 - 00:00:00 CEST