jforum中,通过配置-完后出现这样的问题：java.sql.SQLException: Illegal mix of collations (latin1_swe
发布网友
发布时间：2022-04-13 09:15
我来回答
共2个回答
热心网友
时间：2022-04-13 10:44
An error has occurred.For detailed error information, please see the HTML source code, and contact the forum Administrator.java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' Query being executed when exception was thrown: SELECT r.name, '0' AS role_value FROM jforum_roles r WHERE r.group_id IN (1) UNION SELECT r.name, rv.role_value FROM jforum_roles r, jforum_role_values rv WHERE r.role_id = rv.role_id AND r.group_id IN (1) ORDER BY name通过查资料和分析得知编码问题，于是去mysql下的my.ini,中改编码，
