Corrupted subjects on the archive website

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: pgsql-www(at)postgresql(dot)org
Subject: Corrupted subjects on the archive website
Date: 2015-09-23 04:59:46
Message-ID: CAEepm=1dKk2hG3qQi25GpzABnTir8CiW9TjocJj1x8XTcd6c6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

Hi

Why do some message display with corrupted subjects on the mailing
list archives site? The replies to the message below, but not the
message itself, are displayed with a corrupted subject. They appear
fine in my mail client though.

http://www.postgresql.org/message-id/20150922134404.5050.75087@wrigleys.postgresql.org

The website shows "Re: [BUGS] BUG #13632: violation de l'intégrité rQ1|ɕѥ".
My mail client shows "Re: [BUGS] BUG #13632: violation de l'intégrité
référentielle".

The original message that displays correctly has the following raw header:

Subject: =?utf-8?b?QlVHICMxMzYzMjogdmlvbGF0aW9uIGRlIGwnaW50w6lncml0w6kgcsOp?=
=?utf-8?q?f=C3=A9rentielle?=

The reply that doesn't display correctly has the following raw header:

Subject: =?UTF-8?B?UmU6IFtCVUdTXSBCVUcgIzEzNjMyOiB2aW9sYXRpb24gZGUgbCdpbnTDqWdyaXTDqSBy?=
=?UTF-8?B?w6lmw6lyZW50aWVsbGU=?=

A wise denizen of #postgresql pointed out that 'UTF-8' decoded as
base64 produces 'Q1\377' of which we see at least the 'Q1' in the
corrupted string.

Some other examples of corruption can be seen in the French, Spanish,
Russian etc sections:

http://www.postgresql.org/list/pgsql-es-ayuda/2015-09/

--
Thomas Munro
http://www.enterprisedb.com

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2015-09-23 17:30:48 Re: Corrupted subjects on the archive website
Previous Message Magnus Hagander 2015-09-16 09:39:15 Re: logical-replication mailing list