JForum problem

[Migrated From Jforum.net]

Hi, i have one problem, when i start jforum integrated in my application on my PC i haven't got any problem, all run perfectly, but when i start my application in other computer, and start document.location = "forums/list.page"; javascript link, firefox say me the next message:

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

How i can fix it? thanks you.
[originally posted on jforum.net by MiLLeN]

[Migrated From Jforum.net]

Try to set the charset of all your tables to UTF8.
[originally posted on jforum.net by ebourg]

[Migrated From Jforum.net]

ebourg wrote:Try to set the charset of all your tables to UTF8.

Fixed problem... thanks! ;)
[originally posted on jforum.net by MiLLeN]