例如:
mysql> create table test(name varchar(255));
Query OK, 0 rows affected (0.08 sec)mysql> insert into test values ('中国');
Query OK, 1 row affected, 1 warning (0.03 sec)mysql> select * from test;
+------+
| name |
+------+
| |
+------+
1 row in set (0.00 sec)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.5\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)
我改改哪里的设置,才能让他正常显示中文呢?
mysql> create table test(name varchar(255));
Query OK, 0 rows affected (0.08 sec)mysql> insert into test values ('中国');
Query OK, 1 row affected, 1 warning (0.03 sec)mysql> select * from test;
+------+
| name |
+------+
| |
+------+
1 row in set (0.00 sec)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.5\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)
我改改哪里的设置,才能让他正常显示中文呢?
select * from test;
ERROR 1193 (HY000): Unknown system variable 'NMAE'
mysql> SET NMAES GBK select * from test;
ERROR 1193 (HY000): Unknown system variable 'NMAES'
貌似语法不对
[client]
port=3306
[mysql]
default-character-set=utf8
改成
[client]
port=3306
[mysql]
default-character-set=gb2312然后就没问题了。我当时用的windows命令行来执行的,头儿说,是窗口不支持utf8的原因。我想请问下还有有别的方法来改这个问题吗?
SET NMAES GBK;
select * from test;
select * from test;
set names 'gbk';
insert into test values ('中国');
MySQL 中文显示乱码