mysql>mysql> select LENGTH(RTRIM(SPACE(8)));+-------------------------+| LENGTH(RTRIM(SPACE(8))) |+-------------------------+| 0 |+-------------------------+1 row in set (0.00 sec)