mysql - 无法将unicode插入mysql

Question

当我尝试在mysql中插入unicode(这里是中文)时，mysql出现问题，例如我想插入:

insert into site_parameter(name) values("测试");

但是在mysql终端中，它变成:

mysql> insert into site_parameter(name) values("");
Query OK, 1 row affected (0.00 sec)

我什至无法在mysql终端下输入中文。

这是我的.conf

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

我已经检查了排序规则:

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       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+


mysql> show create table  site_parameter;

| site_parameter | CREATE TABLE `site_parameter` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=388 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |

1 row in set (0.00 sec)

有人可以帮忙吗？

Answer 1

控制台窗口(CMD)中有一个字符集属性。

您可以使用 chcp 命令检查当前或设置另一个 -

>chcp
>will output current

>chcp 65001
>will set utf-8

有关此命令的一些信息 - Chcp .