From: M. Neumann - Prisma Computer <m.neumann@prisma-computer.de>
To: Igor Korot <ikorot01@gmail.com>
To: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
Subject: Re: Fwd: Invalid byte sequence
Date: Thu, 8 Oct 2026 08:13:42 +0200
Message-ID: <29a9f87e-a8b3-4d18-99e5-bc4209a3d2dd@prisma-computer.de> (raw)
In-Reply-To: <CA+FnnTwsULryZT2TcAq1Vsz4ZbmN5gQQ+Kqn2uQ8FUEx0j8ReA@mail.gmail.com>
References: <CA+FnnTzCm8NABjtSnCgqsqgK8-7Uj_w4f3XQ8E457=AqBcxprA@mail.gmail.com>
<CA+FnnTwsULryZT2TcAq1Vsz4ZbmN5gQQ+Kqn2uQ8FUEx0j8ReA@mail.gmail.com>
Hi,
could it be that the database uses an encoding other than UTF-8 (e.g.
SQL_ASCII or LATIN1)? If so, another client may at some point have
written data that cannot be represented in UTF-8. Since your connection
uses UTF-8 as the client encoding, those raw bytes can't be converted,
which would explain why the error only shows up intermittently, i.e.
only when the affected rows are involved.
Am 08.10.2026 um 03:33 schrieb Igor Korot:
> Does anyone have an idea of what is happening?
>
> Thank you.
>
>
> ---------- Forwarded message ---------
> From: *Igor Korot* <ikorot01@gmail.com>
> Date: Tue, Oct 6, 2026 at 12:23 AM
> Subject: Invalid byte sequence
> To: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
>
>
> Hi, ALL,
>
> When run my program and connect to the Postgres server with ODBC
> INTERMITTENTLY receive the error:
>
> ERROR: invalid byte sequence for encoding "UTF8" 0xed 0xbf 0xa0
> Does this sound familiar to anyone?
>
> Thank you.
>
> Trying to google I only got meaningful sugesston for when the last
> byte s 0
>
> I code n C++.
--
Prisma Computer GmbH
Sternallee 89 - 68723 Schwetzingen
Fon 0 62 02.5 75 68 10
Fax 0 62 02.5 75 68 75
eMail:m.neumann@prisma-computer.de
Internet:www.prisma-computer.de
Geschäftsführung: Gerald Wilkens, Martin Goebel
Amtsgericht Mannheim HRB 420986 S
USt-IdNr.: DE 144 278 153
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-odbc@postgresql.org
Cc: m.neumann@prisma-computer.de, ikorot01@gmail.com
Subject: Re: Fwd: Invalid byte sequence
In-Reply-To: <29a9f87e-a8b3-4d18-99e5-bc4209a3d2dd@prisma-computer.de>
References: <CA+FnnTzCm8NABjtSnCgqsqgK8-7Uj_w4f3XQ8E457=AqBcxprA@mail.gmail.com> <CA+FnnTwsULryZT2TcAq1Vsz4ZbmN5gQQ+Kqn2uQ8FUEx0j8ReA@mail.gmail.com> <29a9f87e-a8b3-4d18-99e5-bc4209a3d2dd@prisma-computer.de>
* 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