Re: Retrieving into char variable

Lee Wan Ling wrote: > > Hi there, > I defined a host variable of type array of characters and > retrieved data of type varchar into it. The resultant data is padded > with blanks. > Does anyone knows how I can get INFORMIX to not do so by default? Well, we already know they don't respond to threats and blackmail.. ;-)) OK, here is a tidbit from the ESQL/C Programmer's Manual, Rel 7.2, page 3-5: --- The STRING data type ... holds character data that *is* null terminated and does not contain trailing blanks. --- I have not tried this out myself but it's definitely a start. -- -- Jake (In pursuit of undomesticated aquatic avians) +----------------------------------------------------------+ |Aside from that, how did you enjoy the play, Mrs. Lincoln?| +----------------------------------------------------------+