On 28/01/11 13:12, Wietse Venema wrote: > John Fawcett: > > If UTF8SMTP support is introduced in Postfix, what rules should Postfix >> follow for interpreting email addresses? That if there is at least one >> non-ascii character, the string is treated as utf8 else it is treated as >> ascii? What demands does that place on all the dictionary back ends? >> > All strings will be processed as UTF-8 text. This encoding is 100% > upwards compatible with ASCIIZ text. > > Wietse > so this means that mysql dictionary code should be updated to enforce utf8? If postfix does not enforce utf8 on the connection then the mysql server connection defaults will be used which may not be utf8.
There will also be a requirement that the table columns used in where clause are declared as utf8. If they are not and the %s contains non-ascii characters, it will fail with the illegal collation message that the OP got. John
