Thanks for the reply on this. I have now changed the collation of the
tables to latin1_swedish_ci, but am still getting these errors. Dont
quite understand what todo from here? Can anyone assist further please?
Thanks!!
Simon
The issue is that you are comparing two strings, one that uses one
character set and another which uses a different character set. Mysql
retains (and includes) character set information during string
comparisons - if you were to compare strings with different character
sets, you'd never have a match. It sounds like you have made some
changes to your SQL server recently (or perhaps the changes were made a
while ago and SQL was just recently restarted).
If the table definition defines 'domain' as atin1_swedish_ci, then the
utf8_general_ci is likely coming from the connection between postfix and
MySQL. You might check your my.cnf or startup command for something
similar to 'default-character-set=utf8'. If you find this, I would
suggest reverting to the previous setting (likely commented out or
missing altogether).
--Blake
