Re: trimming chars
Posted in 1998
Exodus — — source: Informix-list mailing list archive (1991-1998)
The Informix trim function will automatically cast into a VARCHAR which can only handle 255 charachters. If you are using livewire, write a trim function in javascript. If you need help with the logic, I think I allready have a function lying around. Ronnie Diaz wrote in message <357C7886.1909D74A@appsig.com>... >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. >-ronnie >