本帖最后由 莫不言 于 2014-7-1 12:27 编辑
mysql> show variables like 'charact%';
+--------------------------+-------------------------------------------+
| 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 | E:\Mysql\MySQL Server 5.5\share\charsets\ |
+--------------------------+-------------------------------------------+
8 rows in set (0.00 sec)
mysql> insert into t1 values (1,'a楞');
ERROR 1366 (HY000): Incorrect string value: '\xC0\xE3' for column 'name' at row
1
mysql> insert into t1 values (1,'a');
Query OK, 1 row affected (0.01 sec)
mysql> show variables like 'charact%';
+--------------------------+-------------------------------------------+
| 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 | E:\Mysql\MySQL Server 5.5\share\charsets\ |
+--------------------------+-------------------------------------------+
8 rows in set (0.00 sec)
mysql> insert into t1 values (1,'a楞');
ERROR 1366 (HY000): Incorrect string value: '\xC0\xE3' for column 'name' at row
1
mysql> insert into t1 values (1,'a');
Query OK, 1 row affected (0.01 sec)
mysql> show create table t1\G;
*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`id` int(11) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
ERROR:
No query specified