Well, about numeric fields..
I'm making some "field type compatibility tests" across dbxoda and dbxmda.
I have a simple app (d2005) with two sqlconnections, one to mysql (5.0.7) and one to Oracle (8.1.7); and one sqlquery.
- set connection in sqlquery to mysql, create persistent fields, numeric are mapped as float. (even is readme tells DECIMAL = BCD but this is another story... )
- close query, switch connection to oracle, open, no errors.
- close query and open again, BUM! Expected BCD actual Float....