pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

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
Date: Fri, 16 Sep 2022 12:06:07 -0400
Message-ID: <3702540.1663344367@sss.pgh.pa.us> (raw)
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>

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

view thread (7+ messages)

Message-ID: <3702540.1663344367@sss.pgh.pa.us>
Permalink:  ../3702540.1663344367@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3702540.1663344367@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, chatterjeesouvik.besu@gmail.com, 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: <3702540.1663344367@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox