Re: trimming chars
Posted in 1998
Ronnie Diaz — — source: Informix-list mailing list archive (1991-1998)
Art S. Kagel wrote: > Ronnie Diaz wrote: > > > > I'm using the trim function on a char field (getting rid of trailing > > whitespaces), and it usually works unless the text is more than 255 > > characters since the object returned to me is a varchar. Does anyone > > know of a way to get trim trailing whitespaces for strings longer than > > 255 chars? Unless I'm missing something (which I usually do) it's silly > > that varchars can only be 255 chars long. > > I assume you are using ESQL/C. Well, I'm not. I'm using Netscape Livewire, and the trailing spaces are added (because I'm using a char(255) field).-ronnie