Chris, Another option is to use | instead of commas. Unless you have pipes in your file. :)
Donny > -----Original Message----- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: Friday, February 20, 2004 2:55 PM > To: Chris Fossenier > Cc: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
