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 CAHE6XHZj02LQQ5HUUsUkF=oM5kvshMPk6tTwgHPJbw2DzsPBFg@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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
So you meant to say registered trademark: ®
is not a valid UTF-8 character?
 
Seems strange to me.

regards,
Souvik Chattopadhyay

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae