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]
