Re: [exim] exim mysql and utf8

Etusivu
Poista viesti
Vastaa
Lähettäjä: Jeremy Harris
Päiväys:  
Vastaanottaja: exim-users
Aihe: Re: [exim] exim mysql and utf8
On 18/02/16 19:21, Juan Bernhard wrote:
> The message is read from a mysql database, the database is in
> utf8. Exim is configured to use header_charset utf8 (this even is not a
> header, but anyway, is the only place when you can configure a charset),
> but exim writes the result as ISO-8859, resulting some characters not
> being displayed correctly.
>
> When I test the exim query expansion i get:
> exim -be '${lookup mysql {SELECT mensaje FROM vacation WHERE usuario =
> "forotecnologico"}}'
> Hola, estoy de vacas.
> ▒▒▒▒▒.▒▒▒▒▒.▒▒▒▒▒▒▒▒▒▒▒▒▒


Try playing with -d-all+expand+lookup and see if you can track the
exact character codes coming in from the DB. This will of course
be confused by the debug output path not being utf8-enabled, but
you might find something relevant.
--
Cheers,
Jeremy