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

[Reggie Burnett]

Thanks Brennon

One thing to know about this issue is that you can work around it without the new version. Basically the problem comes from the server not being able to compare utf-8 and latin1 strings. Our new character set support is good but can be better.

To avoid this issue using the current code on a latin1 table, you would need to use the CAST and CONVERT functions to make sure your literals were latin1. When 1.0.2 comes out, you will still need to use these functiosn when the literals are a different charset than what you selected. So if 99% of your table columns are latin1 but once table is multi-lingual, then you would need to use the CAST and CONVERT operations to make sure those literals were treated correctly.

-reggie