Specifically, I am looking to be able to INSERT a record with a LONG VARCHAR (and to discover what the syntax might be), and to SELECT records based on the contents of a LONG VARCHAR, and to compare a LONG VARCHAR with a string like '%keyword%'.
To insert LONG values, it is best to use PreparedStatements. Although you can have LONG literals in INSERTs, there are restricted in size. The is no way to use LONG columns in predicates (except for IS NULL I think).
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
