著者: Torsten Mueller 日付: To: exim-users@exim.org 題目: [Exim] Problem with non ASCII caracters
Hey,
I use exim 3.31 with mysql support ("virtual hosts"
support).
The problem:
If someone sends mail to info@??? the mail goes
correct to the
spoolfile /var/spool/mail/domain.de/info
but:
mail to infó@domain.de goes to the spoolfile
/var/spool/mail/domain.de/infó
note: there doesn't exists an account infó (don't know if
you can see the "ó", it's
an french o i think).
In my opinion it's a mysql problem, cause mysql should say :
user infó doesn't exist.
Thanks for your help.
Greetings and a happy xmas
Torsten
The mysql part in configure looks like this:
MYSQL_ALIAS = SELECT MYSQL_ALIASFIELD FROM MYSQL_AUTHTABLE
WHERE MYSQL_DOMAINFIELD LIKE '${quote_mysql:$domain}' AND
MYSQL_USERNAMEFIELD LIKE '${quote_mysql:$local_part}' AND
MYSQL_ISALIASFIELD='yes'
MYSQL_ALL_ALIAS = SELECT MYSQL_ALIASFIELD FROM
MYSQL_AUTHTABLE WHERE
MYSQL_DOMAINFIELD='${quote_mysql:$domain}' AND
MYSQL_USERNAMEFIELD='@' AND MYSQL_ISALIASFIELD='yes'
MYSQL_USER = SELECT DISTINCT MYSQL_DOMAINFIELD FROM
MYSQL_AUTHTABLE WHERE MYSQL_DOMAINFIELD LIKE
'${quote_mysql:$domain}' AND MYSQL_USERNAMEFIELD LIKE
'${quote_mysql:$local_part}' AND MYSQL_ISALIASFIELD='no'
MYSQL_DOMAIN = SELECT DISTINCT MYSQL_DOMAINFIELD FROM
MYSQL_AUTHTABLE WHERE MYSQL_DOMAINFIELD='$key'