On 28/01/11 21:56, Wietse Venema wrote: > John Fawcett: > >> 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? >> > No. > > In the purely hypothetical case that the client and server agree > to use UTF8SMTP, Postfix should inform the database that the query > contains UTF-8 text so that the database can convert it appropriately. > > Wietse > if the server advertises UTF8SMTP, how does the client signal that it will use UTF8SMTP?
In the case that Postfix would support UFT8SMTP, the statement given by Mark (SET NAMES 'utf8') will ensure that mysql understands the query is sent in utf8, but there would not be automatic conversion to whatever the column character set is. John
