Re: How do I insert/update >256 CHAR?

John Glassman wrote: > > 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. You forgot to say whether you were using SE or Online? SE has specific limits, like lack of BLOB space, varchar etc. We found when using SE, which has no VARCHAR space that the best way of handling arbitrarily long strings was to create a file, whose name is derived from the serial number of the table row, and then access the file separately in the code. Mind you, this is with ESQL/C and NSAPI, but I'm sure you could do the same with LiveWire and a native library, or even CGI-BIN. Paul P.S. note the mangled email address to trip-up spam-'bots! -------------------------------------------------------------------------- Paul Mansfield, Internet Consultant @ Motiv Systems Ltd snailto:Orwell House.Cowley Road.Cambridge.CB4 4WY.UK Webto: http://www.motiv.co.uk and http://java.motiv.co.uk mailto:p.mansfield@motiv.co.uk phoneto:[+44+223] 576318 faxto:~319 -------------------------------------------------------------------------- 28.8:is it the IQ, or the typical modem speed, on Usenet?