mysql 5.5 字符编码都是utf8的show variables like '%char%';
+--------------------------+---------------------------------------------------| Variable_name            | Value+--------------------------+---------------------------------------------------| character_set_client     | utf8| character_set_connection | utf8| character_set_database   | utf8| character_set_filesystem | binary| character_set_results    | utf8| character_set_server     | utf8| character_set_system     | utf8| character_sets_dir       | D:\Program\MySQL\MySQL Server 5.5\share\charsets\[/color][/color]但是插入中文失败不懂。求指点。。万分感谢
create talbe test(id int primary key,name varchar(20));
mysql> insert into test values(1,'小明');
ERROR 1366 (HY000): Incorrect string value: '\xC3\xF7' for column 'name' at row 1其中建表语句:
mysql> show create table test;
+-------+--------------------------------
| Table | Create Table
+-------+--------------------------------
| test  | CREATE TABLE `test` (
  `id` int(11) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |mysql重装了几次,不管用