Hello,
ok, i solved this.
Am 02.07.2015 um 13:52 schrieb Hajo Locke:
Hello,
i use dovecot 2.2.18 and do some tests with an utf8 mysqlbackend.
I use MySQL to authenticate Users and for retrieving some individual
settings like autocreating folders etc. by userdb-settings in user-query.
Yet no problems with standard language. Now i try to provide
userdb-settings in exotic languages.
My MySQL table uses utf8 charset. I store some data in my userdb-column.
Here an polish example: "namespace/inbox/mailbox=example
namespace/inbox/mailbox/example/name=postępować
namespace/inbox/mailbox/example/auto=subscribe"
In dovecot.conf i used an sql-passdb and prefetching for userdb to save
a query, but this is the point where dovecot performed a latin1
conversion of retrieved utf8 data.
I changed from userdb-prefetch to sql and splitted up into two queries
and all is ok.
Additional i had to use Parameter option_file for dovecot-sql.conf at
connect directive containing "default-character-set=utf8" to make sure
dovecot uses utf8 as default charset varying from default my.cnf
Result is a new folder in dovecot, but in client every special char ę
and ć is replaced with a "?"
I seems that at some point a conversion to latin1 is performed which
ruins the utf8 chars.
Creating a folder postępować by imap-client is no problem.
Hmm, what should i do now? I dont know how to influence dovecot to
process retrieved utf8 data furthermore as utf8.
Which charset is using dovecot when connecting to mysqldb and how to
take influence?
Thanks,
Hajo
Hajo
