How to preserve end spaces in MySQL

[Dong Wang]

It seems that MySQL is removing ending spaces in the insert statements.

mysql> create table temp (c1 varchar(10));
Query OK, 0 rows affected (0.08 sec)

mysql> insert into temp values ('a '); 
Query OK, 1 row affected (0.00 sec)

mysql> select concat(c1, "***") from temp;
+-------------------+
| concat(c1, "***") |
+-------------------+
| a***              |
+-------------------+
1 rows in set (0.00 sec)

How can I preserve the ending space?


> Dong Wang
> Grand Central Networks
> [EMAIL PROTECTED]