Re: Fwd: Invalid byte sequence - Mailing list 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.

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