Andreas Sokov wrote:
> Hi, exim-dev.
exim-dev is for development discussiones, not user questions. I set
reply-to exim-users.
> i use LINUX DEBIAN
http://lists.alioth.debian.org/mailman/listinfo/pkg-exim4-users
> MYSQL query: SELECT id FROM COURIER_PWD WHERE id=CONCAT('andreas', '@', 'j8.com.ru')
> MYSQL: query failed: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
The error message says it all: You use two different collations in your
WHERE condition.
latin1_swedish_ci is the mysql's default collation (IIRC), which can be
changed in my.cnf.
cp1251_general_ci could be the collation of your table.
Change one of these.
There is a bunch of information about this in the mysql docs, e.g.
http://dev.mysql.com/doc/refman/5.0/en/charset-defaults.html and following.