char和varchar有什么区别(What is difference between char and varchar)

CREATE TABLE IF NOT EXISTS `test` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `country` varchar(5) NOT NULL,
  `state` char(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 我尝试了以下查询来插入数据 
 
INSERT INTO `test`.`test` (`id` ,`country` ,`state`)
VALUES (NULL , 'south-india', 'Gujarat');
 
 当我执行上面的查询它将显示以下警告 
 
Warning: #1265 Data truncated for column 'country' at row 1
Warning: #1265 Data truncated for column 'state' at row 1
 
 我发现引用 VARCHAR是可变长度的.CHAR是固定长度的。 
 
 那么你的意思是什么 
 
 VARCHAR是可变长度的。 
 
 CHAR是固定长度的。 

CREATE TABLE IF NOT EXISTS `test` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `country` varchar(5) NOT NULL,
  `state` char(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
I tried following query to insert data
 
INSERT INTO `test`.`test` (`id` ,`country` ,`state`)
VALUES (NULL , 'south-india', 'Gujarat');
 
When I execute above query It will shows following warning
 
Warning: #1265 Data truncated for column 'country' at row 1
Warning: #1265 Data truncated for column 'state' at row 1
 
I found Reference that VARCHAR is variable-length.CHAR is fixed length.
 
Then what you mean by 
 
VARCHAR is variable-length.
 
CHAR is fixed length.

原文：