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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Souvik Chatterjee <chatterjeesouvik(dot)besu(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae
Date: 2022-09-16 03:09:10
Message-ID: 3551124.1663297750@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Souvik Chatterjee <chatterjeesouvik(dot)besu(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Banck 2022-09-16 08:59:45 Re: BUG #15660: pg_dump memory leaks when dumping LOBs
Previous Message Souvik Chatterjee 2022-09-16 02:17:35 Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae