CREATE TABLE `temp_tb33` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(20) DEFAULT NULL,
`desc2` varchar(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
select * from temp_tb33
INSERT INTO test001.temp_tb33
(description, desc2)
VALUES('abc', 'abcd');
INSERT INTO test001.temp_tb33
(description, desc2)
VALUES('abc', 'abcde'); -- Data truncation: Data too long for column 'desc2' at row 1
INSERT INTO test001.temp_tb33
(description, desc2)
VALUES('abc', '一二三四五'); -- Data too long for column 'desc2' at row 1
INSERT INTO test001.temp_tb33
(description, desc2)
VALUES('abc', '一二三四');