> > The integer code should match the codes given by XOPEN and > I've copied > > it from java.sql.types: > > public final static int LONGVARCHAR = -1; > > > > I should probably test that the codes match those given by > mxODBC on the > > same tables. > > > Shouldnt there be a difference between > LONG and LONGVARCHAR (e.g. -1 and -2 ???)
LONG and LONG VARCHAR are the same types in SAP DB (although LONG VARCHAR is valid only in sqlmode oracle). To be consistent with JDBC 3.0, I'd have to return CLOB (2005) for LONG ASCII and LONG UNICODE columns and BLOB (2004) for LONG BINARY. Again, I'll check what mxODBC with the SAP DB ODBC driver says. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
