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

John Glassman wrote: > > Paul, My serever is Online, so I have a choice to display text from > either VARCHAR, CHAR(N), or BLOB(TEXT)...the retrival of the data isn't > my problem... What I'm looking for is a way to place text data larger > then 256 Charaters into a CHAR(N) data field, but I can't pass the data > that large using a SQL statment.I can live with moving a consistant > datablock, but I'm not to hot on the Idea of having to write the data to > a file first since that might add a lot more system overhead in some > cases and it would also creates cleanup and possibly security issues. > > On the other hand..how would you pass text directly to the server and > have it stored as a BLOB(text) type..(does the file have to first > exist?) I know this is probably In the manual somewhere, but I could > realy use a Bootstrap right now Ok, we use ESQL/C 7.1 on Solaris/Sparc InformixOnline, and I had no problem in creating a char(2560) field in a database table and storing and retrieving data from it. If you're using ESQL/C on Wintel, then perhaps there's an oddity with the way you're writing data or the tools you're using... a barrier of 256 seems kind of small! Have you tried a range of sizes just in case, e.g. 255, 511, 1023, etc? 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?