Re: Invalid byte sequence

From: "M(dot) Neumann - Prisma Computer" <m(dot)neumann(at)prisma-computer(dot)de>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: Invalid byte sequence
Date: 2026-10-06 07:40:05
Message-ID: f35d44f7-74f1-40a6-8324-5798e1b9d73d@prisma-computer.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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 06.10.2026 um 09:23 schrieb Igor Korot:
> 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++.

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2026-10-08 01:33:01 Fwd: Invalid byte sequence
Previous Message Igor Korot 2026-10-06 07:23:18 Invalid byte sequence