SQLException: Illegal mix of collations

Hi,

I use jahia 4.1.0_01 build6070 with MySQL 4.1.14. The sever runs under 
linux.

When jahia starts, it generates a SQLException :

     5 [main] ERROR 
org.jahia.services.usermanager.JahiaUserManagerDBProvider.lookupUserInDB:818 
- SQL Exception occured : Co
uld not read the user [root:0]
java.sql.SQLException: Illegal mix of collations 
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '
='
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
        at 
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1347)
        at 
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:958)
        at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
        at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
        at 
org.jahia.services.database.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:77)
        at 
org.jahia.services.usermanager.JahiaUserManagerDBProvider.lookupUserInDB(JahiaUserManagerDBProvider.java:794)
        at 
org.jahia.services.usermanager.JahiaUserManagerDBProvider.lookupUser(JahiaUserManagerDBProvider.java:295)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


This exception appears just after the jahia 's logo in the catalina.out 
file.

I have tried to modify the default-character-set and the 
default-collation properties in the configuration file of MySQL (my.cnf) 
but I always have the same error.

Can someone help me ? I search a solution for 2 days and I have found 
nothing about this error.

Thank you.

 

-- 
MARQUET Ronan - Collaborateur SILICOMP - AQL
Rue de la Châtaigneraie
CS 51766
35517 CESSON SEVIGNE
Tel : 02 99 12 50 00
Fax : 02 99 63 70 40