On Tue, Jun 16, 2009 at 9:50 AM, Blake Hudson <bl...@ispn.net> wrote:
> > 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 > > > Hi Blake, thanks for the reply. The Mysql server that the postfix configuration is on indeed does have default-character-set=utf8 set and this was changed not so long ago.. but we need to have it as such for reasons. I have moved the config to another mysql server (without default-character-set=utf8) for the mean time, but is there a way we can still have default-character-set=utf8 on the mysql server and have the postfix config on it? Thanks Simon
