On Mon, Jun 8, 2009 at 10:09 AM, Darren Pilgrim <post...@bitfreak.org>wrote:
> Simon wrote: > >> Jun 8 07:15:19 mail-in1 postfix/trivial-rewrite[23183]: warning: mysql >> query failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and >> (utf8_general_ci,COERCIBLE) for operation '=' >> Jun 8 07:15:19 mail-in1 postfix/trivial-rewrite[23183]: fatal: >> mysql:/etc/postfix/mysql-transport.cf >> <http://mysql-transport.cf>(0,lock|fold_fix): >> table lookup problem >> >> I have googled and have not really found a solution to this issue... can >> anyone assist please? >> > > This is usually due to comparing a string literal to a function return or a > table with collation set to something other than latin1_swedish_ci (what it > should be for email addresses). Email addresses are always latin1 > case-insensitive. This URL will give you some useful hints: > > http://www.google.com/search?q=Illegal+mix+of+collations+site%3Amysql.com > > Short answer: change the collation on your table or force collation on your > string literal(s). 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
