mysql> describe x; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | y | char(3) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql> insert into x values ('abcd'); Query OK, 1 row affected (0.00 sec) mysql> select y from x; +------+ | y | +------+ | abc | +------+ 1 row in set (0.03 sec) #### ERROR at line 1: ORA-01401: inserted value too large for column