On Thu, Feb 05, 2009 at 02:32:59AM +0100, Michael Monnerie wrote: > On Dienstag 20 Januar 2009 Wietse Venema wrote: > > I have a postfix making SQL queries > > > > > to PostgreSQL, and can see from postgresql logs that postfix does > > > set client_encoding to 'LATIN1' > > > How can I change that to use UTF8? > > > > SMTP is an ASCII protocol, and that is likely not to change. > > But sometimes there is e-mail arriving with bad encoding, example german > umlauts in headers (that's done by Incredimail when used on a mid- > european timezone: Mitteleurop?ische Sommerzeit, Incredimail writes the > Umlaut-a in the header). Is there a way I can get postfix handle this? >
Configure your Postgres database to use a LATIN-1 encoding. WIth this you get a single-byte per character encoding and all byte patterns are valid strings. -- Viktor. Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the "Reply-To" header. To unsubscribe from the postfix-users list, visit http://www.postfix.org/lists.html or click the link below: <mailto:majord...@postfix.org?body=unsubscribe%20postfix-users> If my response solves your problem, the best way to thank me is to not send an "it worked, thanks" follow-up. If you must respond, please put "It worked, thanks" in the "Subject" so I can delete these quickly.