Claudio Prono: > > > >> There is also an initiative to allow UTF-8 characters to appear in SMTP > >> (RFC 5336 and related documents). A malformed UTF-8 could easily > >> appear there, despite being prohibited. If an SQL database would > >> declare an e-mail address field of an UTF-8 data type, a lookup could > >> abort when given such invalid data. > >> > > > > In anticipation of UTF8SMTP support, I added an UTF-8 validator to > > Postfix a while ago. This validator is currently used only in the > > LDAP and SQLITE clients, which are known to require UTF-8. If > > a string is not valid UTF-8, then it is not used in a query. > > > > > Interesting, that can be applicable also to a MySQL ? Maybe this can be > the solution of my problem...
How does MySQL know that the query parameter(s) should be UTF-8 and not ISO LATIN mumble or something else? If this involves additional code someone else will have to write that first. I'm not a MySQL developer. Wietse