Re: HELP!!!! - Informix problems, p.p.p.p.p.p.p.pLEASE!

Hans Nieuwenburg wrote: > > Okay, here it comes (the puzzle of a lifetime) > > 1) Sometimes it looks like Informix destroys some records and makes them > unreadable, i can come up with a solution to repair these records but i > need a structural solution! > Why and how does informix destroy these records? > Could you be a little bit more precise ? At least it would be nice to know which Informix Version and operating system you have. What does "destroys records" mean ? There is no answer to your question without these informations. > 2) 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, is Trim supported in my Informix version If you have a field of type CHAR all values have a fixed length (in your case 10). If you need fields with a variable length you can use the datatype VARCHAR. > > ____________________________________________________________ > > 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 > ____________________________________________________________ Tschuess, Dirk -- --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmidtpott.pad@sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------