Re: Is there varchar2 for informix?

In article <33eb3e7b.16487217@gate.idg.no>, Nils Myklebust <Nils.Myklebust@idg.no> writes >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. I think lvarchar in Universal Server allows you 32K, but I don't think you can index on it directly. -- Chad Hanna Chad Hanna and Associates connect RDBMS to WWW Project Co-ordinator Berkshire Family History Society