List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:September 8 2005 12:05pm
Subject:Re: Trailing spaces removal configurable for char and char binary
data type in MySQL V5
View as plain text  
At 8:50 +0200 9/8/05, Angel Martin wrote:
>     To whom it concerns
>
>     I've been using MySQL V5.0.X for the last 4 months, integrating 
>our application with MySQL. Til now we have been using ORACLE and 
>DB2 and we want to have the chance to offer to our clients the 
>possiblity to use MySQL. We almost have the application migrated 
>entirely to MySQL, but we have the problem that I'll explain on the 
>next lines.
>
>     The MySQL manual indicates that char (binary) and varchar 
>(binary) always remove trailing spaces.

 From MySQL 5.0.3 and up VARCHAR and VARBINARY do not remove trailing
spaces.

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
Trailing spaces removal configurable for char and char binary data type in MySQL V5Angel Martin8 Sep
  • Re: Trailing spaces removal configurable for char and char binarydata type in MySQL V5Paul DuBois8 Sep