List:General Discussion« Previous MessageNext Message »
From:Keith C. Ivey Date:February 20 2004 9:08pm
Subject:Re: White Space
View as plain text  
On 20 Feb 2004 at 14:55, Dan Nelson wrote:

> If you need leading and trailing space stripped, you can postprocess
> the field with the TRIM() function.

But note that, unlike similar functions in some languages, the MySQL 
TRIM() function removes spaces (ASCII 32 characters), not whitespace 
(which generally includes tabs, carriage returns, and line feeds --
and sometimes vertical tabs, form feeds, or nulls -- along with 
spaces).

-- 
Keith C. Ivey <keith@stripped>
Tobacco Documents Online
http://tobaccodocuments.org

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