Re: blanks in LOAD-file

Mark D. Stock wrote: > > ProzessDV wrote: > > > > I want to migrate from a DDB/4 database to OWS 7.22 on SCO 5.0.4. > > Unfortunately, when I use LOAD to insert data into the tables LOAD pads > > char-columns with blanks. Does anybody know how to suppress this filling with > > blanks? > > There is no point, a CHAR or CHARACTER data type in Informix is a fixed > length field. If you want to store a variable length character value, > then define the column as VARCHAR. Also, I don't know what you are using for a fetching tool but in ESQL/C you can define a host variable to be type 'string' and the Informix engine and ESQL/C library will strip the trailing spaces for you and NULL terminate. Art S. Kagel