Re: invalid byte sequence for encoding

From: rob stone <floriparob(at)gmail(dot)com>
To: basti <mailinglist(at)unix-solution(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: invalid byte sequence for encoding
Date: 2017-08-09 13:37:34
Message-ID: 1502285854.4026.1.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2017-08-09 at 14:21 +0200, basti wrote:
> Hello,
> i have a webapp convert from ascii to uft8.
>
> Now I get in postgres
>
> ERROR:  invalid byte sequence for encoding "UTF8": 0xfc
>
> Now I try to log all queries with log_statement = 'all'.
> All queries are longed expected this one.
>
> Is there a way to debug this.
>
> Best Regards,
> Basti
>
>

Hello Basti,

Some more information would be helpful, such as:-
1) Postgres version.
2) The query pulling the error.
3) Table/view definitions.
4) O/S version.
5) How did you actually convert to UTF-8.

Regards,
Robert

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Harry Ambrose 2017-08-09 13:40:04 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100
Previous Message Achilleas Mantzios 2017-08-09 13:29:21 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100