Re: datatype for string

Posted in 2011

Obnoxio The Clown — Tue, 09 Aug 2011 15:23:54 +0100 — source: Usenet: comp.databases.informix

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.