NullPointerException与数据库乱码 about questionansweringsystem HOT 4 CLOSED

请问如何解决这个问题呢？

from questionansweringsystem.

我看第一个issue也是这个问题
#1

from questionansweringsystem.

自行解决了，请参考pull request

from questionansweringsystem.

1、查看MySQL是不是utf8编码
执行如下命令：show variables like "%character%"; show variables like "%collation%";
如果是utf8编码则显示如下：
mysql> show variables like "%character%"; show variables like "%collation%";
+--------------------------+--------------------------------------------------------+
| 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/local/mysql-5.6.20-osx10.8-x86_64/share/charsets/ |
+--------------------------+--------------------------------------------------------+
8 rows in set (0.00 sec)

+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

2、如果不是utf8编码，Mac下的MySQL-5.6.20可通过如下方法修改，其他平台和版本请查询谷歌：
2.1、复制配置文件：
sudo cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
2.2、修改my.cnf：
新增：
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
在[mysqld]下新增：
character-set-server=utf8
2.3、重新启动MySQL服务：
sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart

3、改完编码后删除数据库，重新执行脚本src\main\resources\mysql\questionanswer.sql

from questionansweringsystem.