CHAR(255) DEFAULT 'This will be padded to 255 chars'
mysql> mysql> delimiter $$ mysql> mysql> CREATE PROCEDURE myProc() -> BEGIN -> DECLARE l_char CHAR(255) DEFAULT 'This will be padded to 255 chars'; -> -> select l_char; -> END$$ Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ; mysql> mysql> call myProc(); +----------------------------------+ | l_char | +----------------------------------+ | This will be padded to 255 chars | +----------------------------------+ 1 row in set (0.00 sec)