Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xEhO1-00000001ENz-3Ejk for pgsql-odbc@arkaria.postgresql.org; Thu, 08 Oct 2026 06:13:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xEhO0-00000009yZq-3UUr for pgsql-odbc@arkaria.postgresql.org; Thu, 08 Oct 2026 06:13:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xEhO0-00000009yZh-2Pyl for pgsql-odbc@lists.postgresql.org; Thu, 08 Oct 2026 06:13:48 +0000 Received: from mout.kundenserver.de ([212.227.126.131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xEhNx-000000010eU-0aH2 for pgsql-odbc@postgresql.org; Thu, 08 Oct 2026 06:13:48 +0000 Received: from client.hidden.invalid by mrelayeu.kundenserver.de (mreue009 [213.165.67.97]) with ESMTPSA (Nemesis) id 1M4bA6-1xD2xN1SJ4-005cLx; Thu, 08 Oct 2026 08:13:43 +0200 Received: from [192.168.1.200] (NB-GREGOR.prisma-computer.local [192.168.1.200]) by ip-109-091-148-161.um37.pools.vodafone-ip.de with ESMTP ; Thu, 8 Oct 2026 08:13:42 +0200 Content-Type: multipart/alternative; boundary="------------CXSCYIEQlA2lvRLKL80q722k" Message-ID: <29a9f87e-a8b3-4d18-99e5-bc4209a3d2dd@prisma-computer.de> Date: Thu, 8 Oct 2026 08:13:42 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Fwd: Invalid byte sequence To: Igor Korot , PostgreSQL ODBC list References: Content-Language: de-DE From: "M. Neumann - Prisma Computer" In-Reply-To: X-Provags-ID: V03:K1:usG3kvTrGR47BYECP1v6DYsCeK4efMf81BbGrVnv1a9meg4tu5o BXNykVq5ozeW9FOqPI/zytdeVdwIQegJHSg8KkfyTAwOvw/dWSLlGU0FDQi3ioxTyNn7o4U xYc5HMmXBJHnATJXNu5LfS1e3FhIHPVEOGvr75JzH04I/4kWZ2MzNO418jQgjuNYE3MI2i0 RwEcmfR6r4mf3Y7Q8vQDA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:Motbo1B/Vqg=;hpYpQyFZRrqJPHc6BwqMitit3Fw 4tDH//xK96sXa+NQWzWKZVxhRMgd4arddBQbGY4J3VmkeZ0VNd1BTAF2qvCXQCiaWBct8q9/0 mwgWX5zx4BlbWunYOFeeesY9DYjSOtz3JZAgcdN3ODNmpreKfGjK1wpaa8YGDTdNqYoG0KSoa mSw33l7SM0GIBiMm5S/EdCAeRcatiVrF/ewmWfSokByLq4CD3rBXIE8s0GcQXHGWF/o7GwVvq vo1x6gPo7M6VutvzYmOeEjzRzSN1rnuwO/Sgl8VPD2vC4FYO4KUO6x3a8HpKF2+K/Wn/Rf9mA wdATIYHcenZW15NA/WRYqjMia13lEipTWBoSFDx84g3gnbHCRs0HeRZwev+GxK9/THJPTgdbn DR9q0jqWjvhTq/nqev6kARNpdJim1pfRPh8soyHRG+r0oGc17MTR8QZhCfeyunhmUeFuOEEQN 5B3R6wlxNJO8HR6DXTqnBmCE5c+MQYcEDy3QiWfFNvFATGFLPR1qydzgAs8F+AqqDRTxVIwpF OnFr5agtM8M6oGMbNmTW74tlsRbTj0T+TZs9LDEXVXbIhjk9Y6NTBeuCWL6YAABwYOlQy7xxe 8Otd10b0bypr/JsgvsaEA9RQFa1RVNn2A0hDxlNuAnLp2oh70aV5Sf7BTWd5UEuYyalk5Eubt jyns9I6u7ysuLQJyztWqYJM7tfouNW3kmLPlU8nBv2hpXzM6nEO2z9ismo24NBofF52pErmoB 5VfRLYdMZQREZZLwyS5WpZtuoDuEsgspXgnChbsUBqHYJE2Rxr1ZbeJBMuTBgR5O79ADcI4sg kzMq2XElfv9bJ85Fe5K8YHfEwPBeXRWlFOe4L4F+Ja+S+JIui6nm6d29TngFzJzeqSoqwn1dl hTPpRFxUSJGjBnQ+Icti0B11AMgOUYK2eHecO5lUodtPJkSxrN+CBOdYN0X/rbWYGYtGFgjvy Y+JiuI88T1YsSsnj7I7o65uhp7NTpoGYHR0KwNFEDqmYI5ZNWZaCRlkauO16RxRY66C1VHphC Iwua1SxkkI21hhPc//FjkJVxicFjmtmSgxdQ/uou6EKnYN0Xo+o032xsugE163NVCxWKV2p/c yuonkT0AsUPK1Yui1BUfMd1SF/nskLMl44EtljBDtn6gtupTFoxJ5T2iVOS/uYHu7inOH7fS3 bapgZ+U3ta1lUpyJFNu9svOaPlM2DaYdT35kpemlI2Yil3hWntdj99vhoq5biJFHEvUptrWEU OiDS72Nbscs5hxJ0LyGXEf1tID/OAwlIoHe4nqMckmJawj2jucAzy5bn8N9oQ4mJSgD+0x0rq hB2zwG7Hp7c3LuMTvKHTbbShG2rlU3HSwq+kUCyGH/4ROMvXu5xo6ss4MbX/gF7GmIl5HsDlR Z4O1cks5xWpW4/tCwqIilZwqcD+oSq+FXKPaEMb7gA964qb+NdN7sbjIDjTosrbMJUw8BZ1b2 tz1I1fQRVK5z3Laenndpq6ZGiTQsvvzyiS0UJaUnMJ/kzA9+iPSL6tQC1UUWEpJyqzF8fO0eB Hqx4A0yccpfgma97OC4eIOaKrjpOYbGB6bnN0gQupSgEo7fV+QH6woFGe445G1Q0CyQw1EoIW 3Pa9aK+ipt9yvRtFi127MG+Yfk6/ZXFWObkKal9lal0WjwkNxXM4XZE7brLIr+DT+ADGSWzWV jEjpRB/MGPCcDAUlOFi7PUkVdonE0xoKWGfo6oJJaxfZ9M6I7x9ZIc8y58Li0fG0dCHu1Rg0u Xx27YRAXTzl4jlzfsU2rjxo6b63RpN2uTujtW7FmXtjETGkhGcoQn+itWuZNAnGNg0NEkTdvM ZdSINXdJOXY1R+jGCVfYFTjagl5ev0GKSt1SwpJylQw6DXbEpGr4lo1wK6SPUHdV7K0tBfrE4 yEB+smHnSkanwvjRxTy2y71xDGFYqGp75lN4enkJAVkcNhavZU3PTx3Yf14daueO0ubMQEX3j OHzKlr7fPWIKTlxG8rAlf7bG87k/NXmT9dRghpRHQdzRePN5TGG/T7FqIQlLw7Qk47ZzvlfJd ulfkWUmrGDBNHQLRpxENMwCw5W9FFcuqa9fwWnVHJKn2N2CuKlGg79rzBuHSxEyuc/T9qZfq6 4/X3aIwqwdc+TbkRpJxE+25OEAvEzRFcVft7MMhO7SkmY7ycnSa/3U36hIFV5IUryB9RBr/kt FLYRLwOmfc/Lw+oiqoEOViFYf1fQE8c9jDZCaRS+fWTKwijGECMMjMij881G9PZGccHxyjScd uRYqWkbUVQYrr6ZqNjlJPSOpnJNXOoCQT+zxJ+cNU82Yy+m+ri8ZTCvPVvVw6Lf3pnHWg0P3m 6ruFX+Yl2/953JWd3DvQkhqCpfkzrOGTE3LwvoFxAzN/LX4vOJtN5VB5nV11IfZs7tucpwuEt BWATxq/Ytc4ILhVZncDJTZ1iw//xIxiTq5qhuVbrGU6ChIh6Pq0V+/IrADjbw1tyzKH8e3sq2 OxFB56lum4oX113gM60LLj+1gGidoiIY7FibYuzByvJqOb//lXD3iyMLDhtvk4kdjzBZc1xGy x79xv50Hwho9xww+ItQZSjPZgdfVRjwVxPulnavzlSMoPKDMjFeIXGOM5ynxcY47e0MqwW+YM L2QOeXJOE+LSlMuXJa2hEpS/A8ipwrRAInJLSCcTdZNmH88d8j+et0A== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------CXSCYIEQlA2lvRLKL80q722k Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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* > Date: Tue, Oct 6, 2026 at 12:23 AM > Subject: Invalid byte sequence > To: PostgreSQL ODBC list > > > 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 --------------CXSCYIEQlA2lvRLKL80q722k Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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

--------------CXSCYIEQlA2lvRLKL80q722k--