Another option is to use | instead of commas. Unless you have pipes in your
> -----Original Message-----
> From: Dan Nelson [mailto:dnelson@stripped]
> Sent: Friday, February 20, 2004 2:55 PM
> To: Chris Fossenier
> Cc: mysql@stripped
> Subject: Re: White Space
> In the last episode (Feb 20), Chris Fossenier said:
> > What is the best way to deal with white space in a mysql database?
> > What I'm talking about is trailing spaces in larger fields. We
> > receive data in fixed width format, so when you import it, you get a
> > bunch of trailing white spaces that take up space. Multiply these
> > white spaces by 120million records and it adds up.
> If you use VARCHAR fields, mysql will automatically strip trailing
> whitespace. If you use CHAR fields, stripping space won't help you
> since it's a fixed-width field :)
> If you need leading and trailing space stripped, you can postprocess
> the field with the TRIM() function.
> Dan Nelson
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: