Re: Fwd: Invalid byte sequence

From: "M(dot) Neumann - Prisma Computer" <m(dot)neumann(at)prisma-computer(dot)de>
To: Igor Korot <ikorot01(at)gmail(dot)com>, PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Fwd: Invalid byte sequence
Date: 2026-10-08 06:13:42
Message-ID: 29a9f87e-a8b3-4d18-99e5-bc4209a3d2dd@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 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(at)gmail(dot)com>
> Date: Tue, Oct 6, 2026 at 12:23 AM
> Subject: Invalid byte sequence
> To: PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)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(dot)neumann(at)prisma-computer(dot)de
Internet:www.prisma-computer.de

Geschäftsführung: Gerald Wilkens, Martin Goebel
Amtsgericht Mannheim HRB 420986 S
USt-IdNr.: DE 144 278 153

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Pavel Stehule 2026-11-01 07:02:45 Re: Return trimmed string from the query
Previous Message TomGoodman@mhproez.com 2026-10-08 01:46:44 Re: Fwd: Invalid byte sequence