How do I insert/update >256 CHAR?

Posted in 1997

John Glassman — Sun, 16 Feb 1997 05:52:23 +0100 — source: Informix-list mailing list archive (1991-1998)

Being new to Informix, I hope that someone here can help explain to me how you can Update or Insert Quoted Strings longer than 256 characters into a CHAR(N) data type when a Quoted String in a SQL statement can not exceed 256 Char's? My purpose is to pass Textdata from an html <TEXTAREA> form element through Netscape LiveWire to the Informix WG 7.12 server on AIX 4.14. Is my only way to write the data first to a file and then LOAD it into the DB? (that seems like a big step backwards, if so) Please tell me that I'm just missing something. It seems that this should be an elementary thing to accomplish, but I just can't see how. Many Thanks for all and any help. -- John D. Glassman Loadstone Advertising 1-716-889-5460 MantisMan@loadstone.com http://www.loadstone.com