Tim Bunce wrote:
>
> Thanks for the info. Do you have any strong objections to DBD::Oracle
> replicating the Oracle ODBC results?
>
I just tested with an older driver.
The Oracle 7.3 ODBC driver returns (via DBD::ODBC!):
TYPE PREC SCALE NAME
---- ---- ----- -----------------
2 38 0 CINTEGER
6 15 0 CNUMBER
2 38 0 CNUMBER_38_0
2 11 2 CNUMBER_11_2
2 38 2 CNUMBER_XX_2
6 15 0 CFLOAT
6 15 0 CFLOAT_11
6 15 0 CREAL
6 15 0 CDOUBLE_PRECISION
11 19 0 CDATE
Compare it with 8.1.7 (BTW: I added a DATE column)!
Type 2 is not the problem. Strictly speaking, it's better
than type 3. But the prec. for FLOAT's is garbage!
Now then: which Oracle ODBC results should be replicated?
This one in oci7.c and the other one in oci8.c? Or
always the results from the current version? If so,
the best way is to number the DBI driver like this:
DBD::Oracle733, DBD::Oracle817, DBD::Oracle9xx, ...
Excuse me if I sound a bit sarcastic. But I hope DBI
will continue to mean 'DataBase Independent'.
FYI, here the results from a Visigenic driver:
TYPE PREC SCALE NAME
---- ---- ----- -----------------
3 38 0 CINTEGER
3 0 0 CNUMBER
3 38 0 CNUMBER_38_0
3 11 2 CNUMBER_11_2
3 38 2 CNUMBER_XX_2
8 15 0 CFLOAT
8 15 0 CFLOAT_11
8 15 0 CREAL
8 15 0 CDOUBLE_PRECISION
Steffen
