Private Messages

I concur indubitably my fine chap, shall we have a spot o tea as we dally about?(attempted in my finest Queen'slish)

 

Thank You, That's what I keep telling them
Just gotta keep trying, to keep all smiling

 

You need to change the tables that are latin1_general_ci to latin1_swedish_ci. That was on google

http://stackoverflow.com/questions/1241856/illegal-mix-of-collations-error-in-mysql http://stackoverflow.com/questions/...e-between-utf8-general-ci-and-utf8-unicode-ci

 

Let me know if you want any research on the net for info , and I will try and assist , have lightning speed internet and unlimited download

MySQL Error : Illegal mix of collations for operation 'UNION'
Error Number : 1271

I have had a similar problem in the past. It's caused by mix of collations, most likely cause by differing column collations or default collation for strings.​

This is what you you can try​

• check that the collation is the same for all columns
• check that the collation for your database is the same as your columns
• cast all your columns to the same collation as your database and run your script - then remove the collations in your query to find which column is causing the problem

Otherwise you query looks good.​

Some small feedback on format would be to use joins for readability. Putting all your tables in your 'from' sections and then linking everything in the where clause can get confusing.​

 

This page looked helpful , http://melp.nl/2011/01/about-mysql-u...ing-headaches/

When inserting UTF-8 data into the table using a latin1 connection, the following actually happens:

INSERT INTO t(s) VALUES('á');

The string inserted into the table is sent as the two bytes C3 and A1, which are in turn the characters ‘Ã’ [SUP]1[/SUP] and ‘¡’ (an inverted exclamation mark). MySQL interprets these characters separately and converts them into their UTF-8 counter parts, C2A1 and C383 respectively, taking up a total of 4 bytes of space.

 

Problem is that about half of the tables are in latin1_general_ci and the other half are in latin1_swedish_ci. Why vbulletin would do such a retarded thing is beyond me. I have to go through all of them and change them over.

Thanks for looking it up though.

A quote from your last link:

Not good for someone just learning to to come across a problem involving "one of the most confusing topics ever".......