On 13/09/2016 16:10, Admin Beckspaced wrote:
hello ;)
not sure if this will help? but had a similar issue with mysql queries
a while back.
it actually had nothing to do with postfix and sql lookup tables ...
but ran into trouble with different mysql character sets ... causing
queries to also fail
not sure how your data made it into the mysql tables? but i had
problems with latin-1 characters set ending up in a UTF-8 character
set table and the whole thing got messed up ...
it's called mysql character set hell ;)
this link might help?
https://www.blueboxcloud.com/insight/blog-article/getting-out-of-mysql-character-set-hell
but again ... i'm not sure in your case. just an idea, perhaps it
might help?
Thank you for this link but, since it is a new setup, I have no data.
I've already checked mysql configuration : default character set is
utf8, default collation is utf8_general_ci and database and tables are
using those values. Also, it looks like the data inserted by Modoboa
(the tool I use to manage domains) is encoded using utf8.
I'm still stuck with this and I don't understand why yet...
Antoine
