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

Posted in 1997

Topics: Stored Procedures & SPL, Data Types & Schema Design

John Glassman — Wed, 19 Feb 1997 00:00:15 +0100 — source: Informix-list mailing list archive (1991-1998)

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 -- John D. Glassman Loadstone Advertising 1-716-889-5460 MantisMan@loadstone.com http://www.loadstone.com