Thread: [GENERAL] invalid byte sequence for encoding

[GENERAL] invalid byte sequence for encoding

From
basti
Date:
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


Re: [GENERAL] invalid byte sequence for encoding

From
rob stone
Date:

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