Re: Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92 - Mailing list pgsql-jdbc

From Bosco Rama
Subject Re: Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date
Msg-id 55C8DBFB.8040607@boscorama.com
Whole thread Raw
In response to Re: Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
List pgsql-jdbc
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.


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Re: Fwd: Re: Re: Postgresql 9.4.4 - ERROR: invalid byte sequence for encoding "UTF8": 0x92
Next
From: Christopher BROWN
Date:
Subject: PreparedStatement.setDate() behavior with OVERLAPS