title: Disable the retention of trailing spaces for VARCHAR columns
body: <p>We are considering migrating from MySQL 4.x to MySQL 5.x.</p>
  
  <p>However, beginning with MySQL 5.0.3, trailing spaces are retained in VARCHAR columns, whereas in MySQL 4.x, trailing spaces were not retained for VARCHAR columns.</p>
  
  <p>It was suggested that there might be a MySQL setting that allows us to tell MySQL 5.x to behave as it did in MySQL 4.x, and not retain trailing spaces.</p>
  
  <p>I'm unable to find such a setting, but maybe I'm overlooking it. Is there a way to do this?</p>