On 09/16/2010 07:12 PM, Mikio wrote:
The following bug has been logged online: Bug reference: 5661 Logged by: Mikio Email address: tkbysh2...@yahoo.co.jp PostgreSQL version: 9.0 RC1 Operating system: Windows XP SP3 Japanese Description: The character encoding in logfile is confusing. Details: I'm using postgresql 9.0 rc1 on Japanese Windows XP. I found character encoding is confusing in log files in pg_log directory. Default character encoding of all of databases are UTF-8, and almost message strings in log files are described by UTF-8 correctly. But few lines are described by EUC_JP. So 2 character encoding strings are existing in 1 log file and I can't read the messages parts of logs. Incidentally, client_encoding in postgresql.conf is commented out.
Thankyou for your report. This certainly sounds like a potential bug - but to do anything about it, we will need to see the contents of the actual log file in question and the contents of postgresql.conf .
Only partial log file contents should be necessary, showing the EUC_JP encoded parts of the logs and say ten lines either side. If the EUC_JP contents were generated by client code (say, RAISE NOTICE statements in PL/PgSQL) then you will also need to supply the client code.
Please bundle all the files up in a zip file to protect them from possible text encoding conversion during transfer, and post them to a file hosting site. If you don't want them to be public, just collect the logs up and wait for people to ask you to send them to them by private email. Please send a copy to me, as I've dealt with encoding issues in software (though not PostgreSQL) quite a bit.
-- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
