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).
