List:General Discussion« Previous MessageNext Message »
From:Donny Simonton Date:February 20 2004 9:03pm
Subject:RE: White Space
View as plain text  
Chris,
Another option is to use | instead of commas.  Unless you have pipes in your
file.  :)

Donny

> -----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
> 	dnelson@stripped
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>



Thread
White SpaceChris Fossenier20 Feb
  • Re: White SpaceDan Nelson20 Feb
    • RE: White SpaceDonny Simonton20 Feb
    • Re: White SpaceKeith C. Ivey20 Feb
  • Re: White SpaceBrent Baisley20 Feb
RE: White SpaceChris Fossenier20 Feb