- 论坛徽章:
- 33
|
如果用Xshell、SecureCRT、PuTTY等工具登陆Linux之后操作MySQL,注意把会话的编码设置成UTF-8- mysql> create table t1 (id int, name varchar(10)) DEFAULT CHARSET=gbk;
- Query OK, 0 rows affected (0.07 sec)
- mysql> set character_set_client='gbk';
- Query OK, 0 rows affected (0.00 sec)
- mysql> set character_set_connection='gbk';
- Query OK, 0 rows affected (0.00 sec)
- mysql> set character_set_results='gbk';
- Query OK, 0 rows affected (0.00 sec)
- mysql> insert into t1 values (1,'测试');
- Query OK, 1 row affected (0.01 sec)
- mysql> select * from t1;
- +------+--------+
- | id | name |
- +------+--------+
- | 1 | 测试 |
- +------+--------+
- 1 row in set (0.00 sec)
复制代码 |
|