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