Re: LENGTH of TEXT columns

Please ignore the enclosed message. I found my problem - it was related to not flushing my buffers, nothing to do with Informix or its jdbc drivers. Thanks Sujit From: Sujit Pal on 10/04/2000 11:47 AM To: informix-list@iiug.org cc: Subject: LENGTH of TEXT columns Hello All I am trying to pull out TEXT data from a 7.31 database into a flat file using Java. I notice that the text being pulled out is incomplete. However, the number of characters in the file is exactly equal to the value returned by doing a SELECT LENGTH (textcol) FROM table WHERE condition, so obviously the driver is referring to that value when it decides how much to pull out. Do you think an update statistics would correct the value for the length? Has anyone seen this kind of thing happen before, and if so, what needed to be done. I would have run the update stats first and checked before I asked, but I am not the DBA on the system. TIA Sujit