From: Tom Lane <tgl@sss.pgh.pa.us>
To: Souvik Chatterjee <chatterjeesouvik.besu@gmail.com>
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17615: Getting error while inserting records in the table:
 invalid byte sequence for encoding "UTF8": 0xae
In-reply-to: 
 <CAHE6XHZj02LQQ5HUUsUkF=oM5kvshMPk6tTwgHPJbw2DzsPBFg@mail.gmail.com>
References: <17615-6d24c25ba0e8a9e6@postgresql.org>
 <3421821.1663270405@sss.pgh.pa.us>
 <CAHE6XHZZnQgQaVopmRyPc_LFJcZh41Pd+TGGcsDqUAJwE_y1tQ@mail.gmail.com>
 <3551124.1663297750@sss.pgh.pa.us>
 <CAHE6XHZj02LQQ5HUUsUkF=oM5kvshMPk6tTwgHPJbw2DzsPBFg@mail.gmail.com>
Comments: In-reply-to Souvik Chatterjee <chatterjeesouvik.besu@gmail.com>
	message dated "Fri, 16 Sep 2022 21:18:52 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3702539.1663344367.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Fri, 16 Sep 2022 12:06:07 -0400
Message-ID: <3702540.1663344367@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3702540.1663344367%40sss.pgh.pa.us>
Precedence: bulk

Souvik Chatterjee <chatterjeesouvik.besu@gmail.com> writes:
> So you meant to say registered trademark: ®
> is not a valid UTF-8 character?

I'm sure that there is such a Unicode character, but the way you
are presenting it to the database is not UTF-8.  It's some other
character encoding, probably a single-byte encoding such as a
member of the ISO 8859 family [1].  I see in the table there
that code 0xAE is the trademark symbol in 8859-1 (LATIN1) and
some but not all of the other variants.  You need to arrange
for the proper encoding conversion to happen.  Perhaps reading [2]
would help.

			regards, tom lane

[1] https://en.wikipedia.org/wiki/ISO/IEC_8859
[2] https://www.postgresql.org/docs/current/multibyte.html