Re: HELP!:Informix 5 / Informix NET/ Powerbuilder 4.x " Informix adds spaces to all character type fields, is there a switch? "

Posted in 1996

Josef Dufek — 9 Dec 1996 11:23:10 GMT — source: Informix-list mailing list archive (1991-1998)

Hans Nieuwenburg <Hans.Nieuwenburg@cmg.nl> wrote in article <01bbe357$6d940e20$69ab4fc1@Hans.Nieuwenburg.CMG.NL>... > We are wirking with Informix 5, Informix NET and Powerbuilder 4.x. > > > Every time when we are sending a string like "John" to the field <Name> > (witch is 10 char's long) and we retreve the data like "John " > to reduce extra work on the client software we would like to retrieve the > data with no filling spaces, is there an option in Informix you can use to > set these spaces off? > > Please send reply to > ____________________________________________________________ > > e-mail from : Hans.Nieuwenburg@cmg.nl > DataBases | Programming | Optimizing | DocumentManagement | WorkFlow > ____________________________________________________________ > > CMG Finance | Laan van Kronenburg 14 > 1183 AS Amstelveen, The netherlands > Tel : (031) 020-5033000 > ____________________________________________________________ > > Use varchar instead of char -- HTH, Pepa