Mantis中创建项目时发生的MySQL错误，怎么解决，谢谢

Question

可能是你字符集的之间的连接没有设置好,检查一下吧.
mysql> show variables like "%colla%";
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | gb2312_chinese_ci |
| collation_database   | gb2312_chinese_ci |
| collation_server     | gb2312_chinese_ci |
+----------------------+-------------------+
3 rows in set (0.13 sec)

Answer 1

D:\Program Files\MySQL\MySQL Server 5.0\bin>m
Enter password: ******
Welcome to the MySQL monitor.  Commands end w
Your MySQL connection id is 1 to server versiType 'help;' or '\h' for help. Type '\c' to cmysql> show variables like "%colla%";
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | gb2312_chinese_ci |
| collation_database   | gb2312_chinese_ci |
| collation_server     | gb2312_chinese_ci |
+----------------------+-------------------+
3 rows in set (0.48 sec)mysql>