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

Поиск
Список
Период
Сортировка
От Souvik Chatterjee
Тема Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae
Дата
Msg-id CAHE6XHZZnQgQaVopmRyPc_LFJcZh41Pd+TGGcsDqUAJwE_y1tQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae  (Francisco Olarte <folarte@peoplecall.com>)
Список pgsql-bugs
Дерево обсуждения
We have set the client encoding to UTF-8, but still error is coming.

This is getting saved properly in Oracle databases, then what's the issue postgres?

regards,
Souvik Chattopadhyay

On Fri, 16 Sept 2022, 01:03 Tom Lane, <tgl@sss.pgh.pa.us> wrote:
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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: PANIC in heap_delete during ALTER TABLE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae