Hi, Three datatypes are defined in ODBC 3.X but not defined or known (as far as I can tell) in DBI and DBD::ODBC.
The SQL data types are: SQL_TYPE_DATE (91) SQL_TYPE_TIME (92) SQL_TYPE_TIMESTAMP (93) I use Red Hat 7.2, SAP DB 7.3.0.18, DBI 1.20 and DBD::ODBC 0.31. When running DBD::ODBC make test TEST_VERBOSE=1 I get this output: " ... t/02simple..........1..16 .... Test 3: create test table Using fields: A SMALLINT, B VARCHAR(4000), C LONG, D DATE ok 3 .... Test 9: test ColAttributes Column count is: 4 1: A = 5 2: B = 12 3: C = -1 4: D = 91 not ok 9 .... " SAP DB ODBC returns SQL_TYPE_DATE (91) for the D (DATE) column and the test fails. Can the maintainers of DBI and DBD::ODBC please add the SQL_TYPE_DATE, SQL_TYPE_TIME and SQL_TYPE_TIMESTAMP ODBC 3.X SQL data type constants to DBI and handle SQL_TYPE_DATE in the DBD::ODBC test script; or is there a good reason for not implementing them? Does anybody want me to add them to DBI and DBD::ODBC and supply the diff files? # schoen
