Re: Invalid byte sequence - Mailing list pgsql-odbc

From M. Neumann - Prisma Computer
Subject Re: Invalid byte sequence
Date
Msg-id f35d44f7-74f1-40a6-8324-5798e1b9d73d@prisma-computer.de
Whole thread
In response to Invalid byte sequence  (Igor Korot <ikorot01@gmail.com>)
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.

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++.





pgsql-odbc by date:

Previous
From: Igor Korot
Date:
Subject: Invalid byte sequence
Next
From: Igor Korot
Date:
Subject: Fwd: Invalid byte sequence