If you tell me which you'd like to see and why, and I like what you say,
then your word will be my command (eventually:) !
Better still (and faster still), send me a patch!
Tim.
On Mon, Mar 26, 2001 at 01:06:40PM +0200, Steffen Goeldner wrote:
> 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
