Обсуждение: BUG #18318: Different character codes are mixed in the log file in Japanese locale.

The following bug has been logged on the website:

Bug reference:      18318
Logged by:          Mick ee
Email address:      gomikioshi@gmail.com
PostgreSQL version: 15.2
Operating system:   Windows11
Description:

Different character codes are mixed in the log file in Japanese locale like
following.

2023-12-27 12:52:55.156 JST [10428] LOG:  チェックポイント完了: 7572個のバッファを出力 (46.2%);
0個のWALファイルを追加、0個を削除、5個を再利用; 書き出し=269.047秒, 同期=0.087秒, 全体=269.187秒;
同期したファイル=41, 最長=0.005秒, 平均=0.003秒; 距離=69337 kB, 予測=69337 kB
2023-12-27 12:53:09.914 JST [37840] ERROR:  12譎る俣蠖｢蠑上〒縺ｯ"0"譎ゅ��荳肴ｭ｣縺ｧ縺�
2023-12-27 12:53:09.914 JST [37840] 繝偵Φ繝�:  24譎る俣蠖｢蠑上ｒ菴ｿ縺��°縲√ｂ縺励￥縺ｯ 1 縺九ｉ
12 縺ｮ髢薙〒謖��ｮ壹＠縺ｦ縺上□縺輔＞縲�
2023-12-27 12:53:09.914 JST [37840] 譁�:  select * from temp.kyocera1227 k

    where to_timestamp('2023-12-07 00:00:00','YYYY-MM-DD hh:MI:SS')<  k."Last
seen" 

    
2023-12-27 12:58:25.183 JST [10428] LOG:  チェックポイント開始: time
2023-12-27 12:58:26.657 JST [10428] LOG:  チェックポイント完了: 14個のバッファを出力 (0.1%);
0個のWALファイルを追加、0個を削除、0個を再利用; 書き出し=1.418秒, 同期=0.024秒, 全体=1.474秒; 同期したファイル=7,
最長=0.012秒, 平均=0.004秒; 距離=57 kB, 予測=62409 kB

I can send entire of the some log files.
Regards.

PG Bug reporting form <noreply@postgresql.org> writes:
> Different character codes are mixed in the log file in Japanese locale like
> following.

This is expected, if you're running an installation that has a mix of
different database encodings.  Processes will log in whatever encoding
is used by the database they're connected to.  Processes not connected
to any DB will log in the encoding suggested by the locale
environment.  (At least that's how it works on Unix; less sure about
Windows.)  There's not much we can do to change this.  If we tried to
convert all these to a common encoding, what happens if the encoding
conversion fails?

            regards, tom lane