Re: insert into text data

We use folloing combination to access data Informix Dynamic Server 7.31 the Client-SDK 2.7 > Our ASP program is listed below, which insert data into informix text > field (c1 is char, c2 is text data type). It works but something > strange when I try to query the data through isql tool. > The c2 filed is "21" not "2", and I can't query the data by isql's > form utility. It must use sql command select * from t1 where c1="11". > > <% > set conn = server.createobject("adodb.connection") > conn.open #dsn#, #uid#, #pwd# > v_c1 = "11" > v_c2 = "2" > sql = "insert into t1(c1, c2)" & _ > " values ('" & v_c1 & "','" & v_c2 & "')" > conn.execute sql > %> > > thanks you all!