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 1fb4ew-0001Ma-VH for pgsql-sql@arkaria.postgresql.org; Thu, 05 Jul 2018 13:50:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fb4ev-0004P2-C8 for pgsql-sql@arkaria.postgresql.org; Thu, 05 Jul 2018 13:50:57 +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 1fb4dM-0000QD-DX for pgsql-sql@lists.postgresql.org; Thu, 05 Jul 2018 13:49:22 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fb4dC-0002V5-BF for pgsql-sql@postgresql.org; Thu, 05 Jul 2018 13:49:19 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id 46D2621CDD; Thu, 5 Jul 2018 09:49:08 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 05 Jul 2018 09:49:08 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=imap.cc; h= content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=lVGvaocKV7GYFN2uB2b5ZVDHcbQ1Z ZtZSK/hH4/gd74=; b=mowP+3KSdlVdmeAl/Kn383x+/ssOCQUyG0INBMsheCzmY fJ6KUeMd53j4/rOpDHVA44uJBBYhtaXQwKpnanSUitvnTio25yg2R2JsAhuSlgEk YZBiT9V4JuK6fcec9wg0MtbAqNGfT+1IYppD9t6STn3uo0c2tzN4h7yxlytuDHgK VPiRBg02EfANAqKG9NhiiXFCe8SfQYaykwVbFf0dYHMCSauEFm0yrvpFhQjyCVRB g0TX1DhDEbyA/L4fLpO3CHtCLWHpi9HqmhfpdafRPJwy73IrBdOzStzICcu+s5ZF Od/aBQqio4m34fFWBWuexTTUiRMNUDabbhH58GU9A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=lVGvao cKV7GYFN2uB2b5ZVDHcbQ1ZZtZSK/hH4/gd74=; b=RfMbz0nfSUPWQZrMZTE+u9 ejVuGVUOv6Em/qeRzjyKSFtWPL6Zm3iPMRUpZgvL5AjLKQtCYWE3jxSzCJYGK51k WC5ZEIxgxVqaAOVgYBxnd5IjGQ+gMJ/OjC4kAIZsdwZVzA3l4k+1Ku0rKfOvX7Az Sncx+lpYaT2l0oxigL0ZUJrBVSWZnrYw6M8uZAo94KXiqVMvteSUdnSnrsvNBvmI TF4FnJLx53cxd9SAKCz3s9QvH1DbqePVCY4gmGcU3JomgcXdXGf/7sLyNUv02z1+ x2wNL/mHGe081HBEeab/kseb/iirKeo7Fq1mZ1on/BkXrboJSUsbxFLl02WjyJPA == X-ME-Proxy: X-ME-Sender: Received: from [10.2.33.124] (unknown [185.25.33.70]) by mail.messagingengine.com (Postfix) with ESMTPA id AADFFE473B; Thu, 5 Jul 2018 09:49:07 -0400 (EDT) Subject: Re: Problem inserting binary data in bytea column of UTF-8 database To: =?UTF-8?Q?Brice_Andr=c3=a9?= , pgsql-sql@postgresql.org References: From: Alexey Bashtanov Message-ID: <9dfb240b-dbc5-c9a2-cd28-a249e7329733@imap.cc> Date: Thu, 5 Jul 2018 14:48:59 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Brice, On 03/07/18 05:28, Brice André wrote: > insert into test (test) values (E'\xC744'::bytea); I think double backslash needs to be used. See https://www.postgresql.org/docs/current/static/datatype-binary.html#id-1.5.7.12.9 Best,   Alex