JIRA刚安装好，在浏览器设置应用程序属性添加服务时出错

Question

JIRA刚安装好，在浏览器配置的时候出错了：添加服务时出错：com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, delaytime, CLAZZ, servicename, CRON_EXPRESSION FROM serviceconfig WHERE servicename=? (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=')。
应该怎么办啊

Answer 1

原因是数据库的编码方式有问题，访问mysql数据库，手动修改下表结构的编码方式：alter table serviceconfig convert to character set utf8mb4 COLLATE utf8mb4_general_ci;