invalid byte sequence for encoding

Started by bastiover 8 years ago2 messagesgeneral
Jump to latest
#1basti
mailinglist@unix-solution.de

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2rob stone
floriparob@gmail.com
In reply to: basti (#1)
Re: invalid byte sequence for encoding

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general