Re: Problem inserting binary data in bytea column of UTF-8 database

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: Brice André <brice(at)famille-andre(dot)be>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Problem inserting binary data in bytea column of UTF-8 database
Date: 2018-07-05 13:48:59
Message-ID: 9dfb240b-dbc5-c9a2-cd28-a249e7329733@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2018-07-05 14:04:38 Re: Problem inserting binary data in bytea column of UTF-8 database
Previous Message Brice André 2018-07-03 04:28:48 Problem inserting binary data in bytea column of UTF-8 database