安装mysql是默认编码是UTF-8,windows下,命令行创建表的时候,插入中文就报Incorrect string value: '\xBF\xAA\xB7\xA2' for column 'team错,linux下就不会,请问这是为什么?
好像把编码改成GBK也可以插入。
mysql> create table team(
-> team_id int(5) zerofill primary key,
-> name varchar(20) not null,
-> team_desc varchar(128) default null);
Query OK, 0 rows affected (0.01 sec)
mysql> insert into team values(1,'java','java开发');
ERROR 1366 (HY000): Incorrect string value: '\xBF\xAA\xB7\xA2' for column 'team
desc' at row 1
mysql> 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 | C:\Program Files\MySQL\MySQL Server 5.1\share\char
ets\ |
+--------------------------+---------------------------------------------------
-----+
8 rows in set (0.03 sec)mysql> insert into team values(1,'java','java555');
Query OK, 1 row affected (0.01 sec)
好像把编码改成GBK也可以插入。
mysql> create table team(
-> team_id int(5) zerofill primary key,
-> name varchar(20) not null,
-> team_desc varchar(128) default null);
Query OK, 0 rows affected (0.01 sec)
mysql> insert into team values(1,'java','java开发');
ERROR 1366 (HY000): Incorrect string value: '\xBF\xAA\xB7\xA2' for column 'team
desc' at row 1
mysql> 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 | C:\Program Files\MySQL\MySQL Server 5.1\share\char
ets\ |
+--------------------------+---------------------------------------------------
-----+
8 rows in set (0.03 sec)mysql> insert into team values(1,'java','java555');
Query OK, 1 row affected (0.01 sec)
--传送门
mysql
go