Re: Is there varchar2 for informix?

John Chen <sparkee@stealth.net> wrote: :hello- : : I want to know if there is another E/SQL variable besides text used :to store character arrays with a size greater than 256. : : Thanks- : John - john@boylesoftware.com The only other alternative is char. That of course gives you columns in the database that takes up the same space in every row independent of the actual size of your data. Often not acceptable. Think if we all had Universal Server. The question could have been: Does anyone no of a datablade that implements varchar type columns with size greater than 256 (would like at least 65767 as max size)? If it doesn't allready exist it would probably not be that hard to write. In the meantime there isn't much you can do. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org