无法使用mysql的中文和日文字符

Question

我有一个名为chinese的表，它只有一列name。
show变量如“char%”的输出是:

+--------------------------+--------------------------------------------------------+
| Variable_name            | Value                                                  |
+--------------------------+--------------------------------------------------------+
| character_set_client     | utf8                                                   |
| character_set_connection | utf8                                                   |
| character_set_database   | latin1                                                 |
| character_set_filesystem | binary                                                 |
| character_set_results    | utf8                                                   |
| character_set_server     | latin1                                                 |
| character_set_system     | utf8                                                   |
| character_sets_dir       | /usr/local/mysql-5.1.73-osx10.6-x86_64/share/charsets/ |
+--------------------------+--------------------------------------------------------+

当我运行此查询:insert INTO CHINESE VALUES('')时，将插入这些值。
但是，当我尝试执行此查询:select*FROM CHINESE时，结果是:

+------+
| NAME |
+------+
| ??   |
+------+

从中文中选择十六进制（名称）的结果为:

+-----------+
| HEX(NAME) |
+-----------+
| 3F3F      |
+-----------+

我哪里犯错了？

Answer 1

如果MySQL>=5.5.3，则使用utf8mb4。

1. 更改原始表

ALTER TABLE $tablename
  CONVERT TO CHARACTER SET utf8mb4 
  COLLATE utf8mb4_general_ci

CREATE TABLE $tablename (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE $tablename
    MODIFY $col1
    VARCHAR(191)
    CHARACTER SET utf8mb4;

参考：Mysql单据：列字符集转换