[ Coming late to the thread... ] Steve Atkins <steve@xxxxxxxxxxx> writes: > Fortunately all this stuff is MUA-side, not MTA-side, so exim > should ignore it. SQL_ASCII all the way. I concur. The recent encoding fixes are for the situation where the database server believes a multibyte encoding is in use, but the client code is ignorant of that encoding and either (a) sends invalidly encoded data or (b) does escaping that mangles multibyte characters. If your client-side code is encoding agnostic, then using SQL_ASCII (which is also effectively encoding agnostic) for both client_encoding and server_encoding will work nicely. A possibly safer choice is to use LATIN1 (or another single-byte encoding) instead; this will avoid problems if someone connects to the database with a client_encoding other than SQL_ASCII and expects data to be delivered to him in that encoding. I would *not* recommend using UTF8 if you want to store arbitrary data without worrying about encoding issues. regards, tom lane
