what i really not understand in this post is why the OP doens not change all his charset/collation to UTF8 to avoid mixing?
Am 28.01.2011 23:37, schrieb John Fawcett: > 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
signature.asc
Description: OpenPGP digital signature
