If a field BIG is defined as CHAR or VARCHAR, one would write: CREATE TABLE Users ( mykey number NOT NULL PRIMARY KEY, big varchar(5000) DEFAULT '' ) // INSERT INTO mytable (mykey,big) VALUES (1234,'blah')
This does not work if big is defined to be LONG VARCHAR. What is the SQL syntax for the insert if big is LONG VARCHAR? CREATE TABLE Users ( mykey number NOT NULL PRIMARY KEY, big LONG VARCHAR DEFAULT '' ) // INSERT INTO mytable (mykey,big) VALUES (1234,'what magic goes here?') Mike > Michael Slinn wrote: >> 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 Best regards, Michael Slinn Founder & CTO http://zamples.com 650-345-1140 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
