How to insert a space at the end of a word using CONCAT ?

[pankajit09]

Hi

My SQL query is as below -->

UPDATE rev_log SET keyw=CONCAT(keyw,'  $words  ')

I have put spaces on both sides of $words but only the start space works, the end space doesn't come in the database.

How to do that ?

[ronverdonk]

Standard mySQL documentation:

Trailing spaces are removed when CHAR values are retrieved.
Trailing spaces are removed when VARCHAR values are stored.

Ronald :cool:

[pankajit09]

So is there any way that the trailing spaces are not removed ?