Re: SQLException: Illegal mix of collations

Hi Ronan,

is it a problem that happened after you change 
something either in the configuration of Mysql or 
the database settings of Jahia ? Is it on a fresh Jahia install ?

It seems the default charset of the database and 
the charset of some tables is not the same.

Michel

>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