[egenix-users] way to prevent floats from truncating to ints?

[Nathan Gossett]

I'm using mxODBC to work with an Oracle 9 database, and when I try to 
fetch FLOAT data, they are being returned as ints.  Basically, I'm 
having the same issue as problem two in this posting:

http://www.egenix.com/mailman-archives/egenix-users/2003-June/113452.html

Setting the "leave scale 0 floats untouched" option is not really a 
solution, because then all of the NUMBER(10,0) data is returned as 
floats (which causes problems since they are supposed to be integers). 
I realize that mxODBC is acting exactly as documented, but I need floats 
to be returned as floating point numbers, while integers are returned as 
integers.  Is there some way around this?