Re: DBI, blobs, and strings longer than 256 chars

On Mon, 30 Nov 1998 16:58:16 -0500, "Art S. Kagel" <kagel@bloomberg.net> wrote: > Steven Primrose-Smith wrote: > > > > Hi, > > > > After struggling for an afternoon trying to get blobs into an Informix > > database > > via perl and DBI, without any Informix-specific docs, I wondered is there a > > data type that supports strings longer than 256 chars without resorting to > > blobs. All transactions are carried out via SQL. The database is storing > > some HTML so nothing more than 32KB would be needed. MSAccess can > > manage this, so I figured Informix can too. > > Informix CHAR type is limited to 32767 characters so that should fill > the bill. > > Art S. Kagel That was the solution which I resorted to but I really wanted to use the TEXT type. My data source is flat files ported from another system. Actually, the problems started when I tried to get some test data into my TEXT column. Couln't convert from CHAR or VARCHAR. Couldn't get a 4GL screen to do the insert and dbload didn't do it either. Any ideas? TIA --------------------------------------------------------- Steve Roach: Remove NOSPAM from address to reply: roach@NOSPAMportalinc.com steve_roach@NOSPAMhotmail.com