Re: blanks in LOAD-file

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? > > Thanks in advance for your help, > > Pascal CHAR columns are always padded with blanks. You need VARCHAR columns, which can be a maximum of 255 chars long. An extract from TFM follows: Fixed and Varying Length Data Types The data type CHAR is for fixed-length character data. Use the ANSI-compliant CHARACTER VARYING data type to specify varying length character data. You can also specify varying length data with the Informix VARCHAR data type. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/