Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fyhAG-0005hR-08 for pgsql-bugs@arkaria.postgresql.org; Sat, 08 Sep 2018 17:36:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fyhAD-0003i2-No for pgsql-bugs@arkaria.postgresql.org; Sat, 08 Sep 2018 17:36:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fyhAD-0003hv-He for pgsql-bugs@lists.postgresql.org; Sat, 08 Sep 2018 17:36:53 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fyhAA-0004bD-FM for pgsql-bugs@lists.postgresql.org; Sat, 08 Sep 2018 17:36:52 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1fyhA8-0002HD-5t; Sat, 08 Sep 2018 13:36:48 -0400 Date: Sat, 8 Sep 2018 13:36:48 -0400 From: Bruce Momjian To: orchideric@yahoo.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15373: null / utf-8 Message-ID: <20180908173648.GJ28811@momjian.us> References: <153642745785.23144.1699125571356845227@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <153642745785.23144.1699125571356845227@wrigleys.postgresql.org> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sat, Sep 8, 2018 at 05:24:17PM +0000, PG Bug reporting form wrote: > The following bug has been logged on the website: > > Bug reference: 15373 > Logged by: Eric Hansen > Email address: orchideric@yahoo.com > PostgreSQL version: 10.5 > Operating system: ubu 16 > Description: > > doesn’t support converting NULL bytes to UTF-8 and therefore returns an > error You need to encode binary values containing nulls as bytea strings. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +