On 19 July 2012 10:40, Alexander Law <exclusion@xxxxxxxxx> wrote: >>> Ok, maybe the time of real universal encoding has not yet come. Then >>> we maybe just should add a new parameter "log_encoding" (UTF-8 by >>> default) to postgresql.conf. And to use this encoding consistently >>> within logging_collector. >>> If this encoding is not available then fall back to 7-bit ASCII. >> >> What do you mean by "not available"? > > Sorry, it was inaccurate phrase. I mean "if the conversion to this encoding > is not avaliable". For example, when we have database in EUC_JP and > log_encoding set to Latin1. I think that we can even fall back to UTF-8 as > we can convert all encodings to it (with some exceptions that you noticed). I like Craig's idea of adding the client encoding to the log lines. A possible problem with that (I'm not an encoding expert) is that a log line like that will contain data about the database server meta-data (log time, client encoding, etc) in the database default encoding and database data (the logged query and user-supplied values) in the client encoding. One option would be to use the client encoding for the entire log line, but would that result in legible meta-data in every encoding? It appears that the primarly here is that SQL statements and user-supplied data are being logged, while the log-file is a text file in a fixed encoding. Perhaps another solution would be to add the ability to log certain types of information (not the core database server log info, of course!) to a database/table so that each record can be stored in its own encoding? That way the transcoding doesn't have to take place until someone is reading the log, you'd know what to transcode the data to (namely the client_encoding of the reading session) and there isn't any issue of transcoding errors while logging statements. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
