Re: datatype for string

Personally I prefer using a sub-table of smallish CHAR columns to a large mostly empty LVARCHAR. That is most efficient in space and processing. The only time I would use a large LVARCHAR is when the vast majority of rows will have the column mostly filled but when there are a small but significant number of rows that have no content or very small content. Then I think it is justified. If the size of the actual content of the column varies widely, with most rows having partially full content, I would go the sub-table route. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Aug 9, 2011 at 10:23 AM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > On 09/08/2011 15:21, Art Kagel wrote: > > Use LVARCHAR it's like VARCHAR but can hold up to a bit under 32K bytes. > > It looks like it's not supported by 4GL, much to my surprise, not even > 7.50. > > Sub-table of varchars? :o( > > > On Tue, Aug 9, 2011 at 9:57 AM, eferreyra <eferreyra@gmail.com > > <mailto:eferreyra@gmail.com>> wrote: > > > > Hi, i need to store in a column the text from a exception or log, can > > be up to 2048 chars probly, im using a TEXT column and works fine > > from .NET provider (also JDBC, ODBC) but cant get a INSERT from > > Informix 4gl :( i read that cant be done ? > > > > Cant use CHAR because the space it trashes, cant use VARCHAR is too > > small... > > > > I cant make a LOAD statement, and cant use c funtions or external > > modules... > > > > Suggestions ? > > > > IDS: IBM Informix Dynamic Server Version 11.50.UC6 > > 4GL: IBM INFORMIX-4GL Version 7.32.UC4 > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org <mailto:Informix-list@iiug.org> > > http://www.iiug.org/mailman/listinfo/informix-list > > > > > > > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >