Re: #HY000Illegal mix of collations for operation 'concat'

[Brennon Williams]

Okay Allan,

The place I was getting the error was when I was trying to call SELECT statements with VARCHAR variables so, the following was the normal command string:

SplitTXT = "SELECT * FROM <tablename> WHERE <field> = '<fieldvalue>'"

If your tables are set to use the latin charset/collation then you will need to change the above statement to

SplitTXT = "SELECT * FROM <tablename> WHERE <field> = CONVERT('<fieldvalue>' USING latin1);"

This executes for me without error now, I only hope it does for you. It would appear though that Reggie Says this syntax will still be required even with the next release.

Cheers & Beers
Brennon Williams