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 1xDzmW-00000000rFi-2qX1 for pgsql-odbc@arkaria.postgresql.org; Tue, 06 Oct 2026 07:40:12 +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 1xDzmV-0000000G2l1-1xhg for pgsql-odbc@arkaria.postgresql.org; Tue, 06 Oct 2026 07:40:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xDzmV-0000000G2kt-14cH for pgsql-odbc@lists.postgresql.org; Tue, 06 Oct 2026 07:40:11 +0000 Received: from mout.kundenserver.de ([212.227.126.135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xDzmS-00000000cCQ-3wTR for pgsql-odbc@lists.postgresql.org; Tue, 06 Oct 2026 07:40:10 +0000 Received: from client.hidden.invalid by mrelayeu.kundenserver.de (mreue011 [213.165.67.97]) with ESMTPSA (Nemesis) id 1Mxlmw-1wTCcC1lfy-016bPX for ; Tue, 06 Oct 2026 09:40:06 +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 ; Tue, 6 Oct 2026 09:40:05 +0200 Message-ID: Date: Tue, 6 Oct 2026 09:40:05 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Invalid byte sequence To: pgsql-odbc@lists.postgresql.org References: Content-Language: de-DE From: "M. Neumann - Prisma Computer" In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:i12kGzM6spejOfDUc1zjm+ny7WngfaYK+tA9TsL3F4nlqFHkY76 5QCjPiL3KAfU0R01zHOLGVu7ur61gulP10rlGAFhYVjoY9rkx86Lv5w221bvK9fXIyxcAyF rtL/u2NV6IMNFr/FmWfw3eMp43gVkg2lPGAHV7Xxfmjdv1TcJGwW4B2BXI63PQWdIAzd1nl hcLOhdgHTHyV2wnZtpQZw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:XqwdunYrdUE=;vrrlzQtts7euxDuMTYvmllPTVTh GmsDI1d7II1lPjxwk4ZhHs9gVcu7g1xS81NAfyKPbz3rlcCVWFYlbU9th/r49SAYPsz+ilZeb pFZdOhsSj5+8VkZnnap/Z+/JhkXf8teC9qj1sVeS9YZA8jlCgmwekbvf4PgbCeXHoLwJwzaZ4 mxB7L2K1+TRZVlASP4yn9sekOUltnIy+0M5Nd3F+jedEq0vm8nuZ364bTPkCJaKEl7kQalyTn G6Qim7PGIynC27lLE394ldiSHzu1QYJOWK0N3Nx5yWuXLB7VsG5XHil6yh6Fz4ElqtKAW36AX SsCBTLkamDI1s/TE+DpqHlev9CnADv78VXgYzkjth+76uAnjsPSRLmkaeHWHJ7g5X7x53S8ZV BpDwR7+orD2RAWoUvUJDn/qYqG6YPsrJtOcW0wu9f8kex0t+UAWZeRCWvZqDAjk+X1a2mJRoI 1WzgNgyonEy712XP9XRKxrxwRW50/rr18CN2Iv8kGJHdjRyHo1reyLSRzC2cVVOgOwgvgSt9l GFXpf7v3IVf1nb4nRF07+dYszuaKFhFAzIz+CIxa8NFkE/bDFz0ORgTfjUuEvrcwcrkxZ0TND B1NVHKjJlRJ9tKyOuhDxvgMpkfVpmxbmvQxmlisExLRpwVuQyYBMU30W6QjTneVuci2EEdjJO xvqaMtmE0R2e96fuefX7liM1nxzmPqZH3OkqC8iNFLAFpfFaVw8oQB6q50MFh983dQtUkoLL2 CZyxB9qRgjqJcXTSkdf8JrotAHMVVgHwR1GMlbcSXNAF+fDusfUGR9y88Eq3o/w4jdKw/JnIf 235rjrmyzWr5v0Trxk7oxLxjrBovvWad6UTrQ05Lp5KknKVjxB96fOijx/YzO4Yot7K50v3bs MJri12nvrqBknqQvrrERDhm6CC+9tZBQKQB+1RQBfdxUEFjhy72m46bAHXh4iaXQ9NHKLLVbk l+A5eTIt5VNX2yClan6VarWWoSuxaU0X64IszBNzQbeYxUNskN56aQ8xVu6NZS3mhe1sq0zNC bahWd/e0aoNeD9+Z9uYP9a1Vsp6U4hFa8VJ51FOn1OGTIJltgncjxA8beMtUc55u1I2HPiFfL q1HdmNsYoIs0eK4zmsbz7uKKEwl0y8L/euYKKf1uJtKE49Xy2fw27s/mqnDstLhGtTWs86URn CpdjK84K7bAYnYAgNJDk4qLPEj117H7eVoiXDFNkiMZSnQ3aMJD7zlFRZ9hbQzn+b/Z8Q12F5 G0RB0bUUF27Xg2gEQTyY/el/tG7axNGP6L8Vy5dutCIJTEIRQMMQ2CTgquUbulvVNCuUWbNxj XhsHZ21cPLKTMW8AOSqlCtSjtcycQA1HQhtWhmCfMB+ZHmQWeRs5s91Y5OQOkJyTEW9n4+2BR BrnYz4C18TJvJbG5Nw3gkncTsqXmc6ueYMCRlv8hL4tU1IhIq+dN0Y2GNldaWC94ZH8Rqy0S/ GWO1ELM3TgXmbQtXJmE7pP4lcVZ7hVOPgiJnZbmURWzGtfGTtjwNIs9Tzj4PDFgzCRy6P+ea4 UebNeHWEwNmS8sWNJtMPJpZjt7Dkvx96L+oGqyaeSYYkDjHkZC7bxckLZjgflNF+rs52/U1E8 /I9RKOeFIyVkb7+aXD3DdIC1BKitub9kPKBUa7zvgIaBrpAEVIW4iYQp6I29up1TpBCzWLyF6 WYzE7RHOaJF6q0Hfwvy2PISjM89kgBbb4WCrEFwH8LCeFAb8afUERiFahp0qYVGcwKUI/xEHQ 3Rt3nMOHCC3T7IRFhkwqDVcNKr4IoyVEjj3zYJ5+yTIRc6EEFnEHHO51t6pH29Mmft8Gn1G20 CjqoLWLta6x/D8RdkYOvnb2SaNSdOfRqogOaBHHeWiKxXTuVw6NTyNmhpErN7kg4KqdOXc7Fz IN6O2V2WzV638y4aC+zJ1CRK2m1TDgnRJ1Yd1ppM04uJlawYNAyTcFm3w267PdfpLOvaOS5Rl YtlfLQ8FJJTlp1TINS415213G89WNZx0N+vpSrDEttVZpamJEndI2FIrI4Y0R3gyefi3wnpix Q03z6OyUwttJEckFtN62OtgtMrQpdcictFWxZCvwiXQihg5npx274WApuzVzDK+XN43XJzxT2 xM0ceS9eQ3tuzlfIgWTjwe+84GLHSqBF6HhpRLxNJOoiP1deHU4ncKOsfdq6p2u7sr3KWOMNS lD4k0c2FnTpOVckGGDrC8MtbcfuW3Gp1UiE2bSGhNjO0Nf9dKWTTqimOt9uDQ5vxHaU065r0w IWhlymwBIqzTnu/XlDN0I+S5y7DvaF8NljJKHWMQfhibvPvSWKb5goNRPOPgL6/7+JmFBUDW2 N+ofEIviiU2jLeaZCnES5qvN1C4+DRScV33tAL5mgI6SZhYrjWvAU6bFiKQvl0xVTJPWE6z0C H/Te2fKH8WiVEOvhv7CClMamYzoS0tNCHLa1eN2br49LEJJrYAdBAHsWlWaTDTYHEXY4PK524 Ad1vbTvWw== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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++.