On 08/08/15 14:04, Vladimir Sitnikov wrote:
>> The client is expecting UTF8 while the server is storing un-vetted SQL_ASCII.
>
> I thought server would reconvert it to client_encoding.
> Shouldn't it use client_encoding when sending data to the client?
Yep. And it looks like something not UTF8 got put into that data item.
Either from a restore, a server function or another client that was not
using UTF8 as its encoding.
HTH,
Bosco.