Tim Bunce wrote:
>
> Thanks Steffen. I realised after I sent it that I meant to ask if
> anyone was sure what the situation was with the new types in Oracle 9i.
>
Sorry, if it looked like an Oracle 9i specific test case!
Currently, I have no such system running. The hint regarding new
temporal datatypes is from an Oracle document:
Oracle9i
Database New Features
Release 1 (9.0.1)
June 2001
Part No. A90120-01
My test environment was:
- Oracle 8.1.7 server
- Oracle 8.1.6/8.1.7 client
- Microsoft ODBC Test (ODBCTE32.EXE) from the ODBC SDK
So, the test results refer to Oracle's DATE datatype only!
Let me summarize:
The Oracle ODBC driver returns different TYPE-info for DATE,
depending on the ODBC version in use (via SQLSetEnvAttr):
SQL_OV_ODBC3: 93
SQL_OV_ODBC2: 11
I suggest, that DBD::Oracle follows the SQL_OV_ODBC3 mode and
returns neither 9 nor 11, but 93.
Patch follows.
Steffen
