Re: blanks in LOAD-file

Posted in 1998

Mark D. Stock — Fri, 21 Aug 1998 12:24:11 +0200 — source: Informix-list mailing list archive (1991-1998)

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. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+