mysql varchar

 

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', '一二三四');