PDA

View Full Version : Illegal mix of collation

Sergio68
Tue 18th Apr '06, 2:25pm
And all the posts/threads are mixed up :confused:
What can be done ?

I just moved from one Windows MySql to a Linux one.
Steve Machol
Tue 18th Apr '06, 2:26pm
This is a bug in MySQL 4.1.x. Please see these threads:

Bug report:
http://www.vbulletin.com/forum/bugs.php?do=view&bugid=3627

Workaround:
http://www.vbulletin.com/forum/showthread.php?t=125929

Also MySQL 4.1.12 and up has fixed this problem so you could upgrade your MySQL version.

http://www.vbulletin.com/forum/showthread.php?p=866464#post866464
Sergio68
Tue 18th Apr '06, 2:39pm
Perfect, thx for your time.
Sergio68
Fri 16th Jun '06, 10:38pm
Also MySQL 4.1.12 and up has fixed this problem so you could upgrade your MySQL version.

Now I have MySql 4.1.13 version but today I tried to upgrad eto VB 3.6 beta 2 and suddently averything hang again for an illegal mix of collation.

How can I solve this thing once for ever ? I already set the default character set to latin1 but nothing seems changed :confused:
d3nnis
Mon 19th Jun '06, 12:51pm
Now I have MySql 4.1.13 version but today I tried to upgrad eto VB 3.6 beta 2 and suddently averything hang again for an illegal mix of collation.

How can I solve this thing once for ever ? I already set the default character set to latin1 but nothing seems changed :confused:



check your tables and field columns... is it using a different collation from the database and the collation used by mysql on that server.