Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem inserting binary data in bytea column of UTF-8 database - Mailing list pgsql-sql

From Alexey Bashtanov
Subject Re: Problem inserting binary data in bytea column of UTF-8 database
Date
Msg-id 9dfb240b-dbc5-c9a2-cd28-a249e7329733@imap.cc
Whole thread Raw
In response to Problem inserting binary data in bytea column of UTF-8 database  (Brice André <brice@famille-andre.be>)
Responses Re: Problem inserting binary data in bytea column of UTF-8 database  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Problem inserting binary data in bytea column of UTF-8 database  (Brice André <brice@famille-andre.be>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Brice André
Date:
Subject: Problem inserting binary data in bytea column of UTF-8 database
Next
From: "David G. Johnston"
Date:
Subject: Re: Problem inserting binary data in bytea column of UTF-8 database