mysql>
mysql> select LENGTH(CONCAT(CAST(100000 AS CHAR(6)),'000'));
+-----------------------------------------------+
| LENGTH(CONCAT(CAST(100000 AS CHAR(6)),'000')) |
+-----------------------------------------------+
| 9 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql>