SQLFetch returns 0 bytes for decimal data
522903Jul 12 2006 — edited Sep 12 2006If my application binds decimal columns as SQL_C_CHAR, then I get the data just fine.
But if I bind the decimal columns as SQL_C_NUMERIC and allocate enough room for the SQL_NUMERIC_STRUCT structure, when I issue the SQLFetch for the data, the length returned for the column is 0.
I have no such trouble with, say, the DataDirect ODBC drivers, but I do with Oracle's ODBC drivers.
Any help in this area would be appreciated.
Thanks!