Illegal mix of collations

[Titam]

Hi,

I have this problem with my vbulletin forum :

mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

I would like to know how to change in one times for all my DB the "interclassment" (change latin_swedish_ci for latin1_bin)

I don't know why all my databases are in latin1_swedish_ci ... and where can i modify the set char by default

Thanks a lot,

Titam

 

[jmstacey]

I think you can set the default in the MySQL configuration file (my.cnf)

You can setup the necassary MySQL command to go through every table row check and change the character type.

 

[Titam]

I think you can set the default in the MySQL configuration file (my.cnf)

You can setup the necassary MySQL command to go through every table row check and change the character type.

Thanks again solved