Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae
Date
Msg-id 3421821.1663270405@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> Getting the below error while inserting records into the table:
> invalid byte sequence for encoding "UTF8": 0xae

That is, in fact, an invalidly-encoded character per UTF8 rules,
so I see no reason to think there is any Postgres bug here.
What's more likely is that you haven't set client_encoding to
match the encoding of the data you're trying to insert.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17614: "variable not found in subplan target lists" on grouping query
Next
From: David Rowley
Date:
Subject: Re: huge memory of Postgresql backend process