Wonder how I can insert a large text (exceeding 256 bytes) into a
field in Informix 7.31 of data type TEXT (clob)? I do not want to use sql
statement LOAD to load a file, just want to add a large text from a form in Visual Basic.
IBM informix ODBC driver supports literal as well as parameterized
inserts in a TEXT column.
(Literal inserts into text columns are not supported by IDS .. however ODBC driver works around this limitation to support literal inserts )
Thus your VB application using ODBC driver
should be able to insert into a text column.