Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> I suppose you have databases with the single-byte encoding amidst your
> UTF8 ones. AFAIK the log file registers the log entries in the same
> encoding that the database uses. Different databases can use different
> encodings.
> That's pretty broken, but it's how it is.
Yeah, and it's not easy to improve on. If we tried to convert all
log messages to the same encoding, which one would that be?
(Please, no nonsense about UTF8 being a universal solution.
The Japanese don't think so, for instance.)
Also, what do you do if you get an encoding conversion failure?
That's even before you get into implementation-dependent problems,
like what to do early in process startup before the encoding
conversion machinery is operational.
A more realistic idea might be to have separate log files for
different encodings, though that has a bunch of management issues
to solve as well.
regards, tom lane