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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae
Дата
Msg-id 3551124.1663297750@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae  (Souvik Chatterjee <chatterjeesouvik.besu@gmail.com>)
Список pgsql-bugs
Souvik Chatterjee <chatterjeesouvik.besu@gmail.com> writes:
> We have set the client encoding to UTF-8, but still error is coming.

That is exactly what you *shouldn't* do, because the data you are sending
is evidently not in UTF8.  It's probably some LATINn variant.

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

[ shrug... ]  It's likely a matter of what software stack you have on
the client side, not which server you're using exactly.

            regards, tom lane



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Souvik Chatterjee
Дата:
Сообщение: Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae
Следующее
От: Michael Banck
Дата:
Сообщение: Re: BUG #15660: pg_dump memory leaks when dumping LOBs