Re: Is there varchar2 for informix?

Nils Myklebust <Nils.Myklebust@idg.no> wrote in article <33eb3e7b.16487217@gate.idg.no>... > John Chen <sparkee@stealth.net> wrote: > : I want to know if there is another E/SQL variable besides text used > :to store character arrays with a size greater than 256. > > 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. IUS has lvarchar type, which can be up to 32767 in size. It can handle any type of data (user defined complex data types are stored internally as lvarchar). Really, if you have a single column data item larger than that, you should consider a blob (or smartblob in IUS). The real issue seems to be variable-length data larger than 255 but smaller than say a page. Lvarchar handles this perfectly. However, the original question appears to be referring to ESQL (i.e. C) data types, not SQL types. Dave